Summer Special 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: bestdeal

Free Informatica PR000041 Practice Exam with Questions & Answers

Questions 1

Which of the following statments are valid for Active and Passive Transformations? Choose 2 answers

Options:
A.

A transformation is active if It rearranges the order of the rows in the pipeline

B.

A transformation is active if it does not change the number of rows in the pipeline

C.

Transformations can be active and passive at the same time

D.

A passive transformation will not change the number of rows in the pipeline

Informatica PR000041 Premium Access
Questions 2

Please choose one of the following. In a static, non-multi-row lookup,

Options:
A.

lf a lookup search does not find a value in the search data, then the row from which the search is produced is dropped so a balanced pipeline can be produced

B.

If a lookup search finds the search value in the lookup data but discovers that the fields that are being returned from the search are null, then the row from which the search is produced is dropped so that a balanced pipeline can be produced

C.

If the lookup finds two records that match the search key, it will return two records

D.

None of the above

Questions 3

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

Options:
A.

Yes, by dragging the reusable object into your mapping and unchecklng the Reusable checkbox

B.

Yes' by first clicking the Ctrl key and then dragging the reusable object into the mapping

C.

Yes, by first selecting the reusable object and while dragging the object into your mapping, hold the Ctrl key down

D.

No

Questions 4

How does a single joiner transformation join data?

Options:
A.

From 2 pipeline inputs

B.

From 3 pipeline inputs

C.

From n number of pipeline inputs assuming you have purchased the N-Joiner Option

D.

none of the above

Questions 5

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

Options:
A.

infasetup

B.

infacmd

C.

pmcmd

D.

pmrep

Questions 6

Given the picture shown below:

PR000041 Question 6

Identify all of the true and correct statements listed below. Note: The red (or gray) arrow points at the line in question.

The line on the left hand side of the picture which connects PRODUCT TO PRODUCT_COST : Choose 2 answers

Options:
A.

Describes a LEFT OUTER JOIN between PRODUCT AND PRODUCT_COST

B.

Describes an INNER JOIN between PRODUCT AND PRODUCT_COST

C.

Describes a secondary data flow needed for a sub-select process between PRODUCT AND PRODUCT_COST

D.

Can be created within Informatica PowerCenter

Questions 7

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

Options:
A.

Expression, Router, Joiner

B.

Update Strategy, Expression, Aggregator

C.

Stored Procedure, Joiner, Router

D.

Router, Update Strategy, Joiner

Questions 8

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

Options:
A.

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

B.

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

C.

The lookup condition is limited to only the equal operator

D.

The lookup condition is designated in the ports tab interface via the "L" check box

Questions 9

An Update Strategy transformation has the Forward Rejected Rows attribute unchecked. Which statement is correct and true?

Options:
A.

Records that are tagged for rejection are projected downstream to the next transformation so long as the ports are connected properly

B.

Records that are tagged for rejection are dropped and not projected downstream to the next transformation

C.

The Forward Rejected Rows attribute cannot be cleared after the transformation is created

D.

The Forward Rejected Rows attribute is only applicable when records are tagged for rejection upstream of the Update Strategy transformation

Questions 10

Which command line tool would you use to import a workflow into a repository?

Options:
A.

Infasetup

B.

infacmd

C.

pmcmd

D.

pmrep

Exam Code: PR000041
Certification Provider: Informatica
Exam Name: PowerCenter Data Integration 9.x:Developer Specialist
Last Update: Jul 15, 2025
Questions: 70

Informatica Related Exams

Data-Quality-10-Developer-Specialist - Data Quality 10: Developer Specialist Exam
Informatica Free Access
Get Informatica Full Access

Informatica Free Exams
Informatica Free Exams
Examstrack provides free Informatica exam prep materials and practice tests to support your Informatica certification goals.