Free Practice Questions for Informatica PR000041 Exam

Question 1

Assuming that the value of Fl is 12 as it enters the decode statement, which of the following decode statements will produce the value V? Choose 2 answers

AOption A

BOption B

COption C

DOption D

Correct Answer: A. Option A; C. Option C

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

Correct Answer: A. Worklets can be nested

Question 3

Which statement is correct regarding User-Defined Functions (UDF)?

AA UDF name can contain letters, numbers and underscores

BCan be used in mappings and transformations however not in mapplets

CCan be reused from a shared folder as shortcut

DCan contain Java code snippets

Correct Answer: A. A UDF name can contain letters, numbers and underscores

Question 4

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

Correct Answer: B. The user connects to the service manager of the gateway node, and after authentication and authorization, is re- Assigned to the Repository Service

Question 5

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

AROUND

BTRUNC

CINSTR

DCONCAT

Correct Answer: A. ROUND

Question 6

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

Correct Answer: B. Hash auto-keys

Question 7

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

Correct Answer: C. When the lookup is configured to return multiple rows

Question 8

In which of the following selections are all of the transformations active?

AExpression, Router, Joiner

BUpdate Strategy, Expression, Aggregator

CStored Procedure, Joiner, Router

DRouter, Update Strategy, Joiner

Correct Answer: D. Router, Update Strategy, Joiner

Question 9

Subqueries can be used in the SQL override for uncached lookup transformations.

ATrue

BFalse

Correct Answer: B. False

Question 10

Which statement on workflows is correct?

AIn a default configuration, a workflow must contain at least one session task

BA workflow can contain multiple start points

CIn a default configuration, a workflow parameter file overrides all parameter files in underlying sessions

DAnother workflow cannot be executed from within a workflow

Correct Answer: C. In a default configuration, a workflow parameter file overrides all parameter files in underlying sessions