Informatica PR000007 ICP Exam Practice Test Instant Access

Question 1

What may be gained when registering more than one Integration Service to a single Repository Service?

APerformance

BReliability

CRedundancy to facilitate automatic failover

DAbility to partition the sessions, assuming the partition license option has been purchased

Answer : A

http://dwhlaureate.blogspot.com/2012/09/what-is-intergration-service-in.html

Question 2

What is the PowerCenter Data Transformation Manager process used for'?

ATo manage PowerCenter transformation metadata.

BTo spawn threads that run the sessions and workflows.

CTo dynamically balance the loads of workflows and sessions running in parallel.

DTo allocate memory to all running ETL transformations to ensure efficiency.

Answer : A

http://infatips.com/informatica-powercenter-data-transformation-manager/#.VLtxNWSUdzM

Question 3

What are the three basic security objects that are created and maintained in the Security tab of the Informatica Administrator?

AUsers, Groups. Permissions

BUsers, Groups, Privileges

CUsers, Groups, Roles

DUsers, Groups, Folders

Answer : C

https://community.informatica.com/servlet/JiveServlet/download/10363935937/PC_910_GettingStartedGuide_en.pdf(page 15, security tab)

Question 4

If you attempt to delete a user who is the owner of a repository folder, what will happen?

AThe folder is deleted.

BThe folder becomes owned by Administrator.

CYou will be prompted to assign another owner to the folder.

DThis operation is not allowed.

Answer : B

Question 5

The Service Manager runs which functions on the Master Gateway Node in the domain?

AWorkflows, Configuration, and Alerting.

BSecurity, Web Services, and Alerting.

CSecurity, Configuration, and Alerting.

DWeb Services, Configuration, and Licensing.

Answer : D

https://www.scribd.com/doc/60458347/In-90-Administrator-Guide#download(page 27)

Question 6

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 7

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

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