Online Access Free PR000041 Exam Questions

By default workflows always have a run status of succeeded. Identify the methods to change the run status of the workflow. For the puposes of this question, assume there are no worklets in the workflow.

• A.Check the Fail Parent if this task fails option box on the session task
• B.Use an assignment task to call the ERROR() function
• C.Use a Control Task with a Control Option setting of Fail Me
• D.Use a command task to set the value of $RC to a negative number

Which command line tool would you use to import a workflow into a repository?

• A.infacmd
• B.pmcmd
• C.Infasetup
• D.pmrep

Regarding the Sorter transformation and assuming that Powercenter is not utilizing Pushdown Optimization, select the statement which is correct and true:

• A.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.
• B.When the distinct check box is selected, every port in the sorter transformation will have the sort key selection enabled
• C.If the distinct check box is not checked, the sorter will produce one record per unique key
• D.The Sorter transformation will utilize database indexes from the source database to perform the sort

Which one of the following transformations may be unconnected In a valid mapping? (choose one)

• A.Lookup, stored procedure, Java
• B.Transaction control, Java, lookup
• C.Java, lookup, transaction control
• D.Lookup, stored procedure, external procedure

Which statement is correct regarding User-Defined Functions (UDF)?

• A.A UDF name can contain letters, numbers and underscores
• B.Can be used in mappings and transformations however not in mapplets
• C.Can contain Java code snippets
• D.Can be reused from a shared folder as shortcut