Two pipelines (A & B) are entering a Joiner transformation with each having a record size of 100 bytes. Pipeline A has a total of 1000 records and Pipeline B has a total of 1,000,000 records. Which pipeline should be designated the master pipeline?
A. Both Pipelines should be cached for performance reasons
B. Pipeline B if and only if Pipeline A is sorted
C. Pipeline A
D. Pipeline B
正解:C
質問 2:
Which combination of Transaction Control transformation and target type results in an invalid mapping? (choose one)
A. Dynamic MQ Series target
B. Relational target
C. XML target
D. MS target
正解:D
質問 3:
In which of the following selections are all of the transformations active?
A. Expression, Router, Joiner
B. Update Strategy, Expression, Aggregator
C. Stored Procedure, Joiner, Router
D. Router, Update Strategy, Joiner
正解:D
質問 4:
An Update Strategy transformation has the Forward Rejected Rows attribute unchecked. Which statement is correct and true?
A. The Forward Rejected Rows attribute cannot be cleared after the transformation is created
B. The Forward Rejected Rows attribute is only applicable when records are tagged for rejection upstream of the Update Strategy transformation
C. Records that are tagged for rejection are projected downstream to the next transformation so long as the ports are connected properly
D. Records that are tagged for rejection are dropped and not projected downstream to the next transformation
正解:D
質問 5:
Which of the following statements regarding mapplets are correct and true?
A. A mapplet can contain a source definition as well as a source qualifier
B. Every mapplet must have at least 1 Input transformation as well as 1 Output transformation
C. A mapplet can contain a Normalizer transformation
D. A mapplet can contain a target definition
正解:A
質問 6:
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?
A. At run time, when the workflow is executed, chose the session task with the correct mapping associated
B. 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
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
正解:B
質問 7:
Which of the following is true about database connections?
A. MRS connections may be created in either the Workflow Manager or the Administrator
B. Connections may be created in the Administrator for the MRS and in the Workflow Manager for PowerCenter Repositories
C. Connections may only be created in the Workflow Manager for PowerCenter Repositories and only in the Developer for the MRS
D. PowerCenter connections may be created In either the Administrator or the Workflow Manager
正解:C
Komura -
PR000041問題集は教科書として最適だと思う。