Informatica PR000041 ICP Exam Questions Instant Access

Question 1

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 2

Referring to the Java transformation: select the statement below which is correct and true.

AThe Integration Service starts a JVM that executes the byte code to process data

BPowerCenter requires an Eclipse Java Development Environment for the Java transformation

CNo Third Party Java API's are supported in the Java transformation

DThe Java transformation icon in PowerCenter Designer resembles a coffee bean

Answer : A

Question 3

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 4

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

ATrue

BFalse

Answer : A

Question 5

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

AROUND

BTRUNC

CINSTR

DCONCAT

Answer : A

Question 6

Refering to the Lookup transformation, which statement is correct and true?

AThe lookup condition defines how much memory each of the two caches will consume

BThe lookup condition defines the fields that are used in the search of the data

CThe lookup condition is limited to only the equal operator

DThe lookup condition is designated in the ports tab interface via the 'L' check box

Answer : B

Question 7

Of the statements below, which best describes the underlying process taken when a user connects to a PowerCenter Repository Service for the first time? For the puposes of this question, the PowerCenter Developer is the only PowerCenter client application running, there are 2 nodes in the domain, node 1 is a gateway node and node 2 is a worker node. The PowerCenter Repository Service is running on the worker node.

AThe user connects directly and immediately to the Repository Service

BThe user connects to the service manager of the gateway node, and after authentication and authorization, is re- Assigned to the Repository Service

CThe user connects to the service manager of the worker node that is running the Repository Service, is then authenticated, authorized, and connected to the PowerCenter Repository Service

DThe user first connects to the PowerCenter Integration Service and then after authentication and authorization, is connected to the PowerCenter Repository Service

Answer : B

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