Black Friday Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70special

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

Page: 1 / 7
Total 70 questions

PowerCenter Data Integration 9.x:Developer Specialist Questions and Answers

Testing Engine

  • Product Type: Testing Engine
$37.5  $124.99

PDF Study Guide

  • Product Type: PDF Study Guide
$33  $109.99
Question 1

Regarding the Sorter transformation and assuming that Powercenter is not utilizing Pushdown Optimization, select the statement which is correct and true:

Options:

A.

When the distinct check box is selected, every port in the sorter transformation will have the sort key selection enabled

B.

When 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.

C.

If the distinct check box is not checked, the sorter will produce one record per unique key

D.

The Sorter transformation will utilize database indexes from the source database to perform the sort

Question 2

The HTTP Transformation supports which HTTP Methods? (Choose all that apply) Choose 2 answers

Options:

A.

DELETE

B.

GET

C.

POST

D.

PUT

Question 3

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

Question 4

Which statement on workflows is correct?

Options:

A.

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

B.

A workflow can contain multiple start points

C.

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

D.

Another workflow cannot be executed from within a workflow

Question 5

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?

Options:

A.

5 fields are in the index cache and 3 are in the data cache

B.

3 fields are in the index cache and 2 fields are in the data cache

C.

2 fields are in the index cache and 3 fields are in the data cache

D.

2 fields are in the index and 5 fields are in the data cache

Question 6

Which combination of Transaction Control transformation and target type results in an invalid mapping? (choose one)

Options:

A.

Dynamic MQ Series target

B.

MS target

C.

Relational target

D.

XML target

Question 7

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

Options:

A.

Lookup, stored procedure, external procedure

B.

Lookup, stored procedure, Java

C.

Java, lookup, transaction control

D.

Transaction control, Java, lookup

Question 8

Referring to a lookup transformation: Which of the following statements are true and correct?

Options:

A.

The caching of a flat file is optional if the data in the flat file is sorted

B.

The lookup index cache file contains a searchable index of the records based on the lookup condition

C.

When lookup caching is unchecked, PowerCenter will read from a locally stored cache file

D.

The data cache contains all of the fields in the lookup transformation

Question 9

Which is the correct priority of assigning a mapping variable?

Options:

A.

Workflow parameter file, session parameter file, pre-session assignment, repository value, declared initial value, default value

B.

Session parameter file, workflow parameter file, repository value, declared initial value

C.

Repository value, workflow parameter file, pre-session assignment, session parameter file, default value

D.

Repository value, declared initial value, default value

Question 10

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.

Options:

A.

The user connects directly and immediately to the Repository Service

B.

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

C.

The 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

D.

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

Page: 1 / 7
Total 70 questions