PR000041 Online Practice Questions and Answers

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

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

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

A. Lookup, stored procedure, external procedure

B. Lookup, stored procedure, Java

C. Java, lookup, transaction control

D. Transaction control, Java, lookup

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

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

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 a Control Task with a Control Option setting of Fail Me

C. Use an assignment task to call the ERROR() function

D. Use a command task to set the value of $RC to a negative number

Which combination of Transaction Control transformation and target type results in an invalid mapping? (choose one)

A. Dynamic MQ Series target

B. MS target

C. Relational target

D. XML target

Which of the following statments are valid for Active and Passive Transformations? Choose 2 answers

A. A transformation is active if It rearranges the order of the rows in the pipeline

B. A transformation is active if it does not change the number of rows in the pipeline

C. Transformations can be active and passive at the same time

D. A passive transformation will not change the number of rows in the pipeline

Which attributes of a reusable Expression transformation can be edited within the Mapping Designer workspace?

A. The transformation's name, one of its port's default values, the tracing level or a Metadata Extension

B. The transformation's name or the tracing level

C. The transformation's name, one of its port's default values or the tracing level

D. The transformation's name is the only attribute that can be changed

In the TO_CHAR (date) function, what do the format strings D, DD, and DDD produce? (choose one)

A. Character day of week, character day of month, and character day of year respectively

B. Day of week, day of month, and Julian date since 4713 B.C. 00:00:00 (midnight) respectively

C. Each produces numerical day of week

D. Numerical day of week, day of month, and day of year respectively