The Lookup stage is one of three stages that join records based on the values of key columns. What are the other stages? (Choose two.)

A. Join

B. Merge

C. Modify

D. Funnel

E. Difference

Consider a customer with multiple environments, Development, Test and Production. Which statement is TRUE?

A. Each environment must have a C++ compiler.

B. QualityStage rule sets are not a type of deployable asset.

C. It is not possible to revert to a previous version of a package.

D. A package can contain an improved version of a job which will replace the old one.

Which statement about restartable sequence jobs is TRUE?

A. If a restartable sequence aborts, it can be restarted from Director.

B. Choosing "Reset job" from Director will start the job where it left off.

C. Checkpoints are always added to every eligible Job Activity stage in the sequence.

D. There is no way to force a Job Activity stage to return if the sequence got beyond it.

A job consist of Sequential File Stage -> Copy Stage using auto partitioning -> Sequential File stage. We need the target Sequential File stage rows to be in the same order as the source file. Which collection algorithm should be chosen in the target Sequential File stage?

A. Auto

B. Same

C. Round robin

D. Sorted merge

Your job consists of a DB2 Connector stage followed by a Sort stage followed by a Transformer stage followed by another DB2 Connector stage. The following two Balanced Optimizer options have been selected: Push processing to data sources Push processing to data targets The following two Balanced Optimizer options have NOT been selected: Push data reduction processing to data targets Push all processing into the (target) data server Assuming the job design allows for maximum optimization, what does the optimized job design look like?

A. Row Generator stage followed by a DB2 Connector stage

B. DB2 Connector stage followed by a DB2 Connector stage

C. DB2 stage followed by a Transformer stage followed by a DB2 Connector stage

D. DB2 Connector stage followed by a Sort stage followed by a Transformer stage followed by another DB2 Connector stage

Parallel job column definitions have an SQL type associated with them. Which of the following is TRUE?

A. Use the SQL type when specifying a schema via a file

B. The SQL type is what the parallel job data set understands

C. Use the Parallel tab of the Edit Column Meta Data dialog box to view the SQL type

D. The SQL type is mapped to an underlying data type that the parallel job data set understands

A Parameter Set is a named object that can contain which of the following?

A. Multiple parameters and only one value file

B. Only one parameter and only one value file

C. Multiple parameters and multiple value files

D. Only one parameter and multiple value files

Which of the following is NOT a valid use of stage variables?

A. Storing values to be used in both derivations and constraints

B. Storing values that can be referenced by name in downstream stages

C. Storing values from one row to compare with values in the next row read

D. Storing the result on an expression to be used in multiple output columns

The APT_SubProcessOperator is used for what purpose?

A. It allows you to incorporate a third-party executable into the framework

B. It provides the capability to break predefined operators into sub processes

C. It provides the capability to define custom operators at the sub process level

D. It allows you to incorporate composite operators, which contain more than one operator

Which one of the following stages requires a schema file when using Runtime Column Propagation?

A. Modify Stage

B. Data Set Stage

C. Transformer Stage

D. Sequential File Stage