Informatica pr000041 online test
PowerCenter Data Integration 9.x:Developer Specialist Exam
What students need to know about the pr000041 exam
- Total None Questions & Answers
Question 2
Which of these statements on worklets is correct?
- A. Worklets can be nested
- B. A worklet must be a reusable object
- C. A worklet can be executed separately
- D. A worklet does not have to contain a Start task
Answer:
A
Question 3
An Update Strategy transformation has the Forward Rejected Rows attribute unchecked. Which
statement is correct and true?
- 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
Answer:
B
Question 4
An Unconnected Stored Procedure can run in the following fashions?(Choose all that apply) Choose 3
answers
- A. From an expression
- B. As a Post-Session SQL command
- C. As a Pre-Session SQL command
- D. As the only object In the mapping
Answer:
A,B,C
Question 5
Which of the following Is NOT true of Aggregate functions?
- 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
Answer:
A
Question 6
Which statement on workflows is correct?
- 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
Answer:
C
Question 7
Which of these statements is correct concerning a Lookup transformation's persistent cache?
- A. A persistent cache is stored on disk, and must be named to make it useable in multiple mappings
- B. persistent cache is stored on disk, to refresh the cache the disk files must be deleted manually
- C. When the Integration Service cannot find the persistent cache file and the recache property is not set, the session fails
- D. A persistent cache can only be used by one mapping
Answer:
A
Question 8
The HTTP Transformation supports which HTTP Methods? (Choose all that apply) Choose 2 answers
- A. DELETE
- B. GET
- C. POST
- D. PUT
Answer:
B,C
Question 9
Which of following statements is valid for Dynamic lookups?
- A. Dynamic caching cannot be enabled on a lookup that returns multiple rows per search
- B. A dynamic lookup can only be used with insert mappings, i.e. no update strategies are allowed and the session should be configured as Insert
- C. A dynamic lookup must be cached and persistent
- D. It is possible to update and delete records in a dynamic lookup
Answer:
A
Question 10
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 11
What function could be used to exchange 'i' with 'I' in the COMPANY port given the following
expression? function name{1, COMPANY, 'i' , 'I')
- A. CHOOSE
- B. REPLACECHR
- C. REG_REPLACE
- D. INSTR
Answer:
B