Informatica PR000041 ICP Exam Practice Test Instant Access

Question 1

Which of the following techniques could be used to filter data read from a flat file source?

ACreate a valid condition in the Filter attribute of the flat file's Source Qualifier

BPlace a Filter transformation directly after the flat file's Source Qualifier

CAn Expression transformation with an output port's expression defined to filter records

DAn Expression transformation with all of the output port's default values set to blank

Answer : B

Question 2

Assuming that the Master Pipeline has 5 fields, two of which are part of the join condition and that all fields are connected downstream to the next transformation, how many fields are in the index and data cache files?

A5 fields are in the index cache and 3 are in the data cache

B3 fields are in the index cache and 2 fields are in the data cache

C2 fields are in the index cache and 3 fields are in the data cache

D2 fields are in the index and 5 fields are in the data cache

Answer : A

Question 3

In the TO_CHAR (date) function, what do the format strings D, DD, and DDD produce? (choose one)

ACharacter day of week, character day of month, and character day of year respectively

BDay of week, day of month, and Julian date since 4713 B.C. 00:00:00 (midnight) respectively

CEach produces numerical day of week

DNumerical day of week, day of month, and day of year respectively

Answer : D

Question 4

What function would transform 12.99 to 13.0 and 15.44 to 15.4? (choose one)

AROUND

BTRUNC

CINSTR

DCONCAT

Answer : A

Question 5

The word FALSE is a valid Filter transformation condition?

ATrue

BFalse

Answer : B

Question 6

Transformation: Referring to Active and Passive characteristics - Select the statement which is correct and true.

AIf a transformation's Active property is cleared or not enabled, the transformation becomes passive

BA transformation is active if it does not change the number of rows in the pipeline

CTransformations can be active and passive at the same time

DA passive transformation will not change the number of rows in the pipeline

Answer : D

Question 7

A Router transformation has the following group filter conditions:

-Group A: InputValue = 2 -Group B: InputValue > 1 -Default group

The InputValue Is an integer port. Identify which of the following statements is correct. (Choose one)

AIf InputValue = 2, the output will be routed to Group A only

BIf InputValue = 2, the output will be routed to both groups A and B

CIf InputValue = 2, the router will fail, since rows cannot be routed to multiple groups

DAny positive number values other than 1 or 2 will be routed to the Default group

Answer : B

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