Question 1

What does the function SETVARIABLE ($$Variable, value) do?

Accepted Answer

A)  Assign the minimum value of the two to $$Variable 
B)  Assign the maximum value of the two to $$Variable 
C)  Allows the assignment of a value to a parameter 
D)  Assign the value to $$Variable, unless the value is null

Question 2

Which of the following Is NOT true of Aggregate functions?

Accepted Answer

A)  You can place an aggregate function in a variable port 
B)  You can add a filter condition to calculate values for specific rows In the selected ports 
C)  You can use operators to perform arithmetic within the function 
D)  You can calculate a single value for all rows in a group

Question 3

Based upon the graphic below, which response correctly discribes the outcome of this workflow's execution given the start method: (The workflow is valid) • Workflows > Start Workflow

Accepted Answer

A)  AII objects displayed will be executed 
B)  The Start task only will be executed 
C)  The Start task and the link will execute, while the session task will wait to execute 
D)  The Start task and link only will be execute

Question 4

The constant DD_INSERT may be used in an expression within which transformation or transformations? (choose one)

Accepted Answer

A)  Expression and Update Strategy 
B)  Update Strategy 
C)  Update Strategy and Lookup 
D)  Expression, Aggregator, and Update Strategy

Question 5

Given the picture shown below:  How many columns would be selected from the database using PowerCenter's generated sql statement?

Accepted Answer

A)  2 - Due to the line on the left hand side of the picture 
B)  13 - Based on all of the links entering the Source Qualifier 
C)  3 - Based on the all of the links between the Source Qualifier and the next transformation 
D)  Unknown - We need to know how many columns the target has

Question 6

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)

Accepted Answer

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

Question 7

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

Accepted Answer

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 8

Which of the following is a reusable task available in workflow manager?

Accepted Answer

A)  Decision 
B)  Assignment 
C)  Control 
D)  Command

Question 9

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

Accepted Answer

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

Question 10

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

Accepted Answer

A)  A UDF name can contain letters, numbers and underscores 
B)  Can be used in mappings and transformations however not in mapplets 
C)  Can be reused from a shared folder as shortcut 
D)  Can contain Java code snippets

Question 11

If after running a session task, it has been determined that the incorrect mapping was run for that session task, which of the following actions could be attempted?

Accepted Answer

A)  Edit the session task and from the General tab, choose the correct mapping to reassociate with the session task, then Save and rerun the process 
B)  At run time, when the workflow is executed, chose the session task with the correct mapping associated 
C)  Edit the session task and from the Mapping tab, choose the correct mapping to reassociate with the session ask, then Save and rerun the process 
D)  None of the above

Question 12

When using the Joiner transformation and assuming that you are not employing the Push Down Optimization feature, which statement is correct?

Accepted Answer

A)  The data from the detail pipeline Is used to build the cache files used In the join process 
B)  The data from the master pipeline is used to build the cache files used in the join process 
C)  The cache files are built according to a sql override found on the Joiner Properties tab 
D)  The Joiner transformation uses the database to build the join result

Question 13

Which of the following statements is correct on workflow events?

Accepted Answer

A)  A predefined (or file-wait) Event Wait task waits for a file to appear at the specified location. As soon as the file appears, the event succeeds and the file can be processed by the subsequent mapping 
B)  A user-defined event can be created a-d raised in one workflow and then used In another 
C)  A predefined (or file-wait) Event Wait waits for a file to appear at the specified location. As soon as the file appears, it is deleted and the subsequent task will start. 
D)  A user-defined event can be created in either the Event Wait or Event Raise task

Question 14

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

Accepted Answer

A)  Expression, Router, Joiner 
B)  Update Strategy, Expression, Aggregator 
C)  Stored Procedure, Joiner, Router 
D)  Router, Update Strategy, Joiner

Question 15

Given this picture of a PowerCenter Mapping and assuming there is no SQL override in the Source Qualifier:  Identify all of the true and correct statements listed below.

Accepted Answer

A)  This picture depicts a join that will be processed within the Informatica PowerCenter engine 
B)  This picture depicts a join that will be processed in a database 
C)  This picture depicts a SQL UNION operation 
D)  This picture depicts an Informatica Homogeneous Join

Question 16

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

Accepted Answer

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 17

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

Accepted Answer

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

Question 18

The Informatics Date/Time datatype supports values up to which level? (choose one)

Accepted Answer

A)  Picosecond 
B)  Microsecor|d 
C)  Nanosecond 
D)  Millisecond

Question 19

Referring to Informatica Domain Architecture, select the statement which is correct and true.

Accepted Answer

A)  A worker node does not use a service manager 
B)  The OS process that is running after the service manager is started is called pmserver 
C)  The service manager on node 1 will directly monitor services on node 1 and node 2. This is why it is called the gateway manager. 
D)  Nodes within a domain are identified by their name, a hostname and portnumber

Question 20

Transformation: Referring to Active and Passive characteristics - Select the statement which is correct and true.

Accepted Answer

A)  If a transformation's Active property is cleared or not enabled, the transformation becomes passive 
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

Exam 3: PowerCenter Data Integration 9.x:Developer Specialist