Informatica PR000007 ICP Exam Practice Test Instant Access

Question 1

Which statement best describes the characteristics of system-defined roles?

ACreated by Administrator, cannot be edited or deleted.

BCreated by Informatica, may be edited or deleted by Administrator.

CCreated by informatica, cannot be edited or deleted by Administrator.

DCreated by Administrator, may be edited or deleted by Administrator.

Answer : C

Question 2

To run a pmcmd command line command and then confirm the command has run successfully, which method would be used?

ARead the return code visually or in a shell script or batch file.

BCheck the status of the command in the Workflow Monitor.

CRun the command from the informatica Administrator and check the status after the command has completed.

DCreate and configure an Email alert within the workflow Monitor.

Answer : B

Question 3

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?

AStart all nodes, update database configuration on each node, enable application services.

BUpdate database configuration on each node, start all nodes, enable application services.

CEnable application services, start all nodes, update database configuration on each node.

DStart all nodes, enable application services, update database configuration on each node.

Answer : D

Question 4

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"?

ADelete duplicate objects in the destination folder prior to copying.

BRename duplicate objects In the destination folder prior to copying.

CResolve duplicate conflicts with 'replace' or 'reuse.'

DResolve duplicate conflicts with 'rename' and manually provide an alternate name for the object.

Answer : B

Question 5

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

AThe Default Administrator is automatically created during installation. Domain Administrators must be created manually.

BThe Domain Administrator is automatically created for all domains, and the Default Administrator must be created during the domain installation process.

CThe Default Administrator is user supplied during the installation process, and the Domain Administrator Is the built-in super user for everyday domain administration.

DBoth users are automatically created in all domains, but the Domain Administrator is used to maintain only domain objects, while the Default Administrator can be used to manage any Informatica object including clients.

Answer : A

Question 6

How many different repository services can be associated with a single integration service?

AOne

BOne or more

CZero or more

DOne if the integration service is not part of a grid, more than one if It is part of a grid

Answer : A

http://datawarehouse.ittoolbox.com/groups/technical-functional/informatical/associating-a-single-repository-with-two-integration-services-3300097

Question 7

Why should you use PowerCenter Metadata Exchange (MX) views rather than querying the PowerCenter repository tables directly- i.e. the ones that begin with OPB_?

AQuerying the PowerCenter repository tables directly is a violation of the PowerCenter license and terms of use.

BPowerConter repository tables store most data in proprietary binary format and hence are not directly readable. This binary format improves performance.

CStored (hard-coded) queries against the repository tables may become invalid upon a repository version upgrade due to the fact that the repository table structures may change.

DIt is not possible to query the repository tables directly.

Answer : B

Informatica PR000007 PowerCenter Data Integration 9.x Administrator Specialist ICP Exam Practice Test