Informatica PR000007 ICP Exam Practice Test Instant Access

Question 1

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 2

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 3

Which connection types are allowed for the Informatica Administrator interface?

AHTTPS

BHTTP or HTTPS

CHTTPS or LDAP

DNative or LDAP

Answer : B

Question 4

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 5

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 6

Which PowerCenter application(s) can be used to start a workflow?

AThe Workflow Manager.

BThe Workflow Monitor.

CThe Workflow Manager or the Workflow Monitor.

DThe Workflow Manager, the Workflow Monitor, or the Informatica Administrator.

Answer : A

Question 7

Which kinds of objects are stored in a PowerCenter Repository?

AMapping objects, sources and targets, workflow objects, operating system semaphores.

BMapping objects, sources and targets, workflow objects, workflow run information.

CSource data, sources and targets, workflow objects, workflow run information.

DMapping objects, target data, workflow objects, workflow tasks.

Answer : B

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