Informatica PR000041 ICP Exam Practice Test Instant Access

Question 1

Two pipelines (A & B) are entering a Joiner transformation with each having a record size of 100 bytes. Pipeline A has a total of 1000 records and Pipeline B has a total of 1,000,000 records. Which pipeline should be designated the master pipeline?

APipeline A

BPipeline B

CBoth Pipelines should be cached for performance reasons

DPipeline B if and only if Pipeline A is sorted

Answer : A

Question 2

The HTTP Transformation supports which HTTP Methods? (Choose all that apply) Choose 2 answers

ADELETE

BGET

CPOST

DPUT

Answer : B, C

Question 3

When would a Lookup transformation be classified as active?

AWhen the setting for lookup policy on multiple match is Use Any Value

BA lookup cannot be an active transformation

CWhen the lookup is configured to return multiple rows

DA lookup is always active

Answer : C

Question 4

Given this picture of a PowerCenter Mapping and assuming there is no SQL override in the Source Qualifier:

Identify all of the true and correct statements listed below. Choose 2 answers

AThis picture depicts a join that will be processed within the Informatica PowerCenter engine

BThis picture depicts a join that will be processed in a database

CThis picture depicts a SQL UNION operation

DThis picture depicts an Informatica Homogeneous Join

Answer : B, C

Question 5

By default workflows always have a run status of succeeded. Identify the methods to change the run status of the workflow. For the puposes of this question, assume there are no worklets in the workflow.

ACheck the Fail Parent if this task fails option box on the session task

BUse a Control Task with a Control Option setting of Fail Me

CUse an assignment task to call the ERROR() function

DUse a command task to set the value of $RC to a negative number

Answer : C

Question 6

Which command line tool would you use to execute a workflow?

Ainfasetup

Binfacmd

Cpmcmd

Dpmrep

Answer : C

Question 7

Which one of the following transformations may be unconnected In a valid mapping? (choose one)

ALookup, stored procedure, external procedure

BLookup, stored procedure, Java

CJava, lookup, transaction control

DTransaction control, Java, lookup

Answer : A

Informatica PowerCenter Data Integration 9.x:Developer Specialist PR000041 ICP Exam Practice Test