PR000041 Practice Exam Questions and Answers

A.  

Assign the minimum value of the twoto $$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

A.  

lnput

B.  

Output

C.  

Variable

D.  

Return

A.  

A lookup created using a pipeline which contains a target

B.  

A lookup cache split over pipelines of a partitioned mapping

C.  

A lookup associated with the Source Qualifier or an Application source such as JMS or SAP

D.  

A pipeline lookup does not exist

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

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

A.  

ROUND

B.  

TRUNC

C.  

INSTR

D.  

CONCAT

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

A.  

Filter, Joiner, Rank

B.  

Union, Filter, Aggregator

C.  

Rank, Lookup, Aggregator

D.  

Joiner, Rank, Sorter

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

A.  

The NextVal column produces the next number in the sequence

B.  

The cycle check box on the properties tab turns on a feature that randomizes the numbers but still produces a unique set of numbers for the sequence

C.  

The default ending value for a PowerCenter 9.x Sequence Generator is 2,147,483,647

D.  

The Sequence Generator contains a single input port that represents the initial starting point of the sequence