PR000041 PowerCenter Data Integration 9.x:Developer Specialist

Exam Code: PR000041
Exam Name: PowerCenter Data Integration 9.x:Developer Specialist
[ Total Questions: 70]

Question No : 1 In the Expression transformation graphic below, what is the value of the PREVIOUS_STATE port for row 2, given that the value for the STATE port was ‘CA’ for row 1?
A. STATE
B. ‘CA’
C. NULL
D. Value of the PREVI0US_STATE port is based upon its declared default value Answer: B
Question No : 2
What function would transform 12.99 to 13.0 and 15.44 to 15.4? (choose one)
A. ROUND
B. TRUNC
C. INSTR
D. CONCAT Answer: A
Question No : 3 A Pipeline Normalizer transformation will reflect one input port for each occurs value which Is greater than 1.
A. True
B. False Answer: A
Question No : 4
Can you use a Decode function to perform multiple searches based on a single search value?
A. No
B. Yes
C. Yes, but only if the port being searched Is sorted first
D. Yes, but only if the port is downstream of a router transformation Answer: B
Question No : 5
Which of the following is not a Transaction Control Variable?
A. TC_CONTINUE_TRANSCTION
B. TC_COMMIT_TRANSACTION
C. TC_ROLLBACK_BEFORE
D. TC COMMIT AFTER Answer: B
Question No : 6 Which of the following are supported file types, from which, an XML definition can be imported? Choose 3 answers
A. XML
B. XSD
C. DTD
D. DSDL Answer: A,B,C
Question No : 7
What is the first column of the bad file?
A. Reject reason
B. Column Indicator
C. Overflow Indicator
D. Row Indicator Answer: D
Question No : 8
Which of the following is true about database connections?
A. Connections may only be created in the Workflow Manager for PowerCenter Repositories and only in the Developer for the MRS
B. Power Center connections may be created In either the Administrator or the Workflow Manager
C. MRS connections may be created in either the Workflow Manager or the Administrator
D. Connections may be created in the Administrator for the MRS and in the Workflow Manager for Power Center Repositories
Answer: A