PR000041 by Informatica Valid Free Exam Practice Test

Question 1

Which command line tool would you use to execute a workflow?

A. infacmd B. pmcmd C. pmrep D. infasetup

Correct Answer: B

Question 2

From within your folder, is it possible to make a non-reusable copy of a reusable transformation for use in a mapping?

A. Yes' by first clicking the Ctrl key and then dragging the reusable object into the mapping B. Yes, by first selecting the reusable object and while dragging the object into your mapping, hold the Ctrl key down C. Yes, by dragging the reusable object into your mapping and unchecklng the Reusable checkbox D. No

Correct Answer: B

Question 3

Can you use a Decode function to perform multiple searches based on a single search value?

A. Yes, but only if the port is downstream of a router transformation B. Yes C. Yes, but only if the port being searched Is sorted first D. No

Correct Answer: B

Question 4

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)

A. Any positive number values other than 1 or 2 will be routed to the Default group B. If InputValue = 2, the output will be routed to both groups A and B C. If InputValue = 2, the output will be routed to Group A only D. If InputValue = 2, the router will fail, since rows cannot be routed to multiple groups

Correct Answer: B

Question 5

Which one of the following transformations may be unconnected In a valid mapping? (choose one)

A. Java, lookup, transaction control B. Transaction control, Java, lookup C. Lookup, stored procedure, Java D. Lookup, stored procedure, external procedure

Correct Answer: D

Question 6

Referring to an Unconnected Lookup transformation: Which one of the following is true? (choose one)

A. Both connected and unconnected lookups can return only one row B. An unconnected lookup may return only one value while a connected lookup may return multiple rows C. An unconnected lookup can return multiple rows while a connected lookup may return only one D. Both connected and unconnected lookups can return multiple rows

Correct Answer: B

Question 7

Which attributes of a reusable Expression transformation can be edited within the Mapping Designer workspace?

A. The transformation's name, one of its port's default values or the tracing level B. The transformation's name or the tracing level C. The transformation's name is the only attribute that can be changed D. The transformation's name, one of its port's default values, the tracing level or a Metadata Extension

Correct Answer: B

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