Informatica PR000041 ICP Exam Practice Test Instant Access

Question 1

What is a pipeline lookup transformation?

AA lookup created using a pipeline which contains a target

BA lookup cache split over pipelines of a partitioned mapping

CA lookup associated with the Source Qualifier or an Application source such as JMS or SAP

DA pipeline lookup does not exist

Answer : C

Question 2

Which of the following are supported file types, from which, an XML definition can be imported? Choose 3 answers

AXML

BXSD

CDTD

DDSDL

Answer : A, B, C

Question 3

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

AROUND

BTRUNC

CINSTR

DCONCAT

Answer : A

Question 4

In the Expression transformation graphic below, what is the value of the PREVIOUS_STATE port for row 2, given that the value for the STATE port was 'CA' for row 1?

ASTATE

B'CA'

CNULL

DValue of the PREVI0US_STATE port is based upon its declared default value

Answer : B

Question 5

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 6

Which of the following statements regarding mapplets are correct and true?

AA mapplet can contain a target definition

BA mapplet can contain a source definition as well as a source qualifier

CEvery mapplet must have at least 1 Input transformation as well as 1 Output transformation

DA mapplet can contain a Normalizer transformation

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 Practice Test