INFORMATICA PowerCenter Data Integration 9.x Administrator Specialist

Question - 30 Maximum mark : - 56

Home
All Exams
INFORMATICA PowerCenter Data Integration 9.x Administrator Specialist Online Practice Exams
INFORMATICA PowerCenter Data Integration 9.x Administrator Specialist

What is the purpose of operating system profiles?

To allow two or more workflows to run on the same node under different operating system users. ✘ To allow two or more Integration Services to run on the same node under differed operating systemusers. ✘ To allow two or more workflows to run on the same node while accessing different database connectionusers. ✘ To allow two or more Integration Services to run a single workflow on two or more different nodes withdifferent operating systems. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which statement is true regarding object copy across folders in the Repository Manager?

You can copy an object even though it has been checked out or has a write-intent lock. ✘ The Repository service will lock the repository database until the objects have been copied. ✘ It is best practice to export the objects as XML prior to performing the copy operation. ✘ You must have write permissions in both the origin folder and the destination folder. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

In reference to relational connections created in the PowerCenter Workflow Manager, which one of the following statements is true?

The connection environment SQL executes when a session connects to the database. ✘ The transaction environment SQL executes Just before a COMMIT against the target. ✘ The transaction environment SQL causes PowerCenter to ignore the Transaction ControlTransformation. ✘ You can use the connection environment SQL to set folder permissions in the PowerCenter repositorydatabase. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Pmcmd is used for which of the following tasks?

Delete workflow, schedule workflow, ping service. ✘ Start workflow, schedule workflow, ping service. ✘ Start workflow, delete task, ping service. ✘ Start workflow, schedule workflow, copy workflow. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Why would a repository service be placed in Exclusive mode?

If the repository service will be the only service running on a node. ✘ If the repository service is not to be configured to run in backup mode. ✘ In order to change a property of the repository service. ✘ If it is desired to prevent the repository service from running as part of a grid. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

In Informatics 9.x, which is true about domain configuration backup using the infasetup command line program'?

It Backs up the domain database and all service databases that are part of that domain. ✘ It backs up domain metadata to another domain database. ✘ It backs up the domain configuration to a binary file. ✘ It backs up the domain to two binary files, one of which holds an index and the other the data. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Infacmd is used to administer which of the following objects?

Domain gateway, log events, workflows, application services. ✘ Versioning. log events, grids, application services. ✘ Domain gateway, log events, grids, application services. ✘ Domain gateway, clients, grids, application services. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

What is the difference between the Default Administrator and the Domain Administrator users'?

The Default Administrator is automatically created during installation. Domain Administrators must be
created manually. ✘ The Domain Administrator is automatically created for all domains, and the Default Administrator mustbe created during the domain installation process. ✘ The Default Administrator is user supplied during the installation process, and the DomainAdministrator Is the built-in super user for everyday domain administration. ✘ Both users are automatically created in all domains, but the Domain Administrator is used to maintainonly domain objects, while the Default Administrator can be used to manage any Informatica object
including clients. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You have coped a set of PowerCenter objects to a new folder, Many of the objects that now appear in the destination folder have a "1" appended to their names, such as 'Targetname1 instead of the expected Targetname. How would you recommend avoiding this situation in the future"?

Delete duplicate objects in the destination folder prior to copying. ✘ Rename duplicate objects In the destination folder prior to copying. ✘ Resolve duplicate conflicts with "replace" or "reuse." ✘ Resolve duplicate conflicts with "rename" and manually provide an alternate name for the object. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

You are migrating a domain to a new domain database. What is the correct order of the next actions to complete the migration once the new domain database is successfully restored?

Start all nodes, update database configuration on each node, enable application services. ✘ Update database configuration on each node, start all nodes, enable application services. ✘ Enable application services, start all nodes, update database configuration on each node. ✘ Start all nodes, enable application services, update database configuration on each node. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Prev Next

Congratulations

you have successfully completed the test

Back to Question View Result

Detail Form

We will send your result on your email id and phone no. please fill detail

Name

Email ID Note: Report will be send to the above Email ID

Phone No

INFORMATICA PowerCenter Data Integration 9.x Administrator Specialist

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner