Informatica PR000041 ICP Exam Practice Test Instant Access

Question 1

What is the first column of the bad file?

AReject reason

BColumn Indicator

COverflow Indicator

DRow Indicator

Answer : D

Question 2

Which of these statements on worklets is correct?

AWorklets can be nested

BA worklet must be a reusable object

CA worklet can be executed separately

DA worklet does not have to contain a Start task

Answer : A

Question 3

A Pipeline Normalizer transformation will reflect one input port for each occurs value which Is greater than 1.

ATrue

BFalse

Answer : A

Question 4

The user creates a mapping by using aggregator transformation. The aggregator transformation receives sorted input from sorted transformation. What is the dafault partition type for aggregator transformation?

APass-through

BHash auto-keys

CNot a valid partition points

DBased on the transformation scope

Answer : B

Question 5

Regarding the Sorter transformation and assuming that Powercenter is not utilizing Pushdown Optimization, select the statement which is correct and true:

AWhen the distinct check box is selected, every port in the sorter transformation will have the sort key selection enabled

BWhen transformation scope is set to a value of transaction, the sorter will sort on every record in the pipeline before it releases any data. The intermediate sort file will have markers for each transaction.

CIf the distinct check box is not checked, the sorter will produce one record per unique key

DThe Sorter transformation will utilize database indexes from the source database to perform the sort

Answer : A

Question 6

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 7

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

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