Which statement is correct regarding User-Defined Functions (UDF)?
A. Can be used in mappings and transformations however not in mapplets
B. A UDF name can contain letters, numbers and underscores
C. Can contain Java code snippets
D. Can be reused from a shared folder as shortcut
正解:B
質問 2:
Regarding the Sorter transformation and assuming that Powercenter is not utilizing Pushdown Optimization, select the statement which is correct and true:
A. The Sorter transformation will utilize database indexes from the source database to perform the sort
B. If the distinct check box is not checked, the sorter will produce one record per unique key
C. When the distinct check box is selected, every port in the sorter transformation will have the sort key selection enabled
D. 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
質問 3:
What function would transform 12.99 to 13.0 and 15.44 to 15.4? (choose one)
A. INSTR
B. TRUNC
C. ROUND
D. CONCAT
正解:C
質問 4:
When would a Lookup transformation be classified as active?
A. A lookup cannot be an active transformation
B. When the setting for lookup policy on multiple match is Use Any Value
C. A lookup is always active
D. When the lookup is configured to return multiple rows
正解:D
質問 5:
Which of the following statements is correct on workflow events?
A. A user-defined event can be created a-d raised in one workflow and then used In another
B. 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.
C. 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
D. A user-defined event can be created in either the Event Wait or Event Raise task
正解:B
質問 6:
Which of the following is not a Transaction Control Variable?
A. TC_ROLLBACK_BEFORE
B. TC_CONTINUE_TRANSCTION
C. TC COMMIT AFTER
D. TC_COMMIT_TRANSACTION
正解:D
質問 7:
Given the picture shown below: How many columns would be selected from the database using PowerCenter's generated sql statement?
A. 13 -Based on all of the links entering the Source Qualifier
B. 2 -Due to the line on the left hand side of the picture
C. Unknown - We need to know how many columns the target has
D. 3 -Based on the all of the links between the Source Qualifier and the next transformation
正解:D
Matsushita -
合格しました。Pass4TestさんのおかげですこのPR000041参考書を利用して一ヶ月で合格することができました。この参考書と過去問を解けば合格できると思います!