Informatica PR000007 ICP Exam Practice Test Instant Access

Question 1

A node has been selected in the Informatica Administrator Domain Navigator window. The Processes tab for this node contains which of the following items?

AAll of the service processes and their statuses.

BAll of the workflows running on the node.

CAll of the service processes running on the node that are disabled.

DAll of the service processes running on the node that are enabled.

Answer : D

Question 2

Infacmd is used to administer which of the following objects?

ADomain gateway, log events, workflows, application services.

BVersioning. log events, grids, application services.

CDomain gateway, log events, grids, application services.

DDomain gateway, clients, grids, application services.

Answer : D

Question 3

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

AIt Backs up the domain database and all service databases that are part of that domain.

BIt backs up domain metadata to another domain database.

CIt backs up the domain configuration to a binary file.

DIt backs up the domain to two binary files, one of which holds an index and the other the data.

Answer : C

http://www.bianalyticschannel.com/2013/12/09/how-to-migrate-informatica-repositoriesto-another-database/

Question 4

Why would a repository service be placed in Exclusive mode?

AIf the repository service will be the only service running on a node.

BIf the repository service is not to be configured to run in backup mode.

CIn order to change a property of the repository service.

DIf it is desired to prevent the repository service from running as part of a grid.

Answer : C

Question 5

Pmcmd is used for which of the following tasks?

ADelete workflow, schedule workflow, ping service.

BStart workflow, schedule workflow, ping service.

CStart workflow, delete task, ping service.

DStart workflow, schedule workflow, copy workflow.

Answer : B

http://www.folkstalk.com/2012/10/pmcmd-command-usage-in-informatica.html

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