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

Which application(s) can be used to copy a PowerCenter repository folder?

AThe Repository Manager.

BThe Repository Manager or the Informatica Administrator.

CThe Repository Manager or the Designer.

DAny application except the Workflow Monitor.

Answer : B

Question 3

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 4

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

Question 5

Which of the following permissions can be associated with a PowerCenter repository folder?

AGrant

BExecute

CCreate global objects

DCreate runtime objects

Answer : B

http://gerardnico.com/wiki/dw/etl/informatica_powercenter/powercenter_security#permi ssions

Question 6

Which connection types are allowed for the Informatica Administrator interface?

AHTTPS

BHTTP or HTTPS

CHTTPS or LDAP

DNative or LDAP

Answer : B

Question 7

Which statement best describes the process when a user connects to a PowerCenter Repository Service for the first time?

Assume the following:

-PowerCenter Developer is the only PowerCenter client application running -There are 2 nodes in the domain, node 1 is a gateway node and node 2 is a worker node -The PowerCenter Repository Service is running on the worker node

AThe user connects directly and immediately to the Repository service.

BThe user connects to the service manager of the gateway node, and after authentication and authorization, is reassigned to the Repository Service.

CThe user connects to the service manager of the worker node that is running the Repository service, is then authenticated, authorized, and connected to the PowerCenter Repository service.

DThe user first connects to the PowerCenter Integration Service and then after authentication and authorization, is connected to the PowerCenter Repository Service.

Answer : C

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