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

Which of the following will determine the running row number within a group?

A. Insert an Aggregator stage, hashing on the key column, prior to the Transformer stage

B. Use a Surrogate Key Generator stage to generate the running row number prior to the Transformer stage

C. Use a Remove Duplicates stage prior to the Transformer stage based on the key column, with the Duplicate set to retain = last option

D. Use a Sort stage prior to the Transformer stage based on the key break column. Then, use the LastRowinGroup() function to determine the last row in a group

Your job aggregates data before writing the results out to a DB2 table. You have since learned that this job will be required to aggregate very large amounts of data. To ensure high performance you create a new, non-default configuration file for the job that defines a node pool named "highperfnodes" that includes only nodes with very high processing power.

What additional design changes do you need to make to the job to ensure that it aggregates the data using the "highperfnodes" pool? (Choose two.)

A. Select the "highperfnodes" pool in the Execution tab of the Job Properties window

B. Add the $APT_CONFIG_FILE environment variable as an additional job parameter

C. Add a Sort stage before the Aggregator stage to sort the data before the data is aggregated

D. Change properties in the Aggregator stage to force it to use the nodes in the appropriate pool

E. Change properties in the Aggregator stage to force it to use the new non-default configuration file

Which Slowly Changing Dimension (SCD) stage statement is TRUE?

A. Surrogate keys are used to join a dimension table to a fact table in a normalized schema database

B. Each SCD stage processes multiple dimensions and performs lookups by using an equality matching

C. Purpose codes are part of the table metadata that the SCD stage propagates to the dimension insert link.

D. Actual dimensions changes are applied to the lookup table in memory and are mirrored to the dimension update link

In your project there is a top level Sequencer job which has multiple sub sequencers and jobs. You have to move this Sequencer job to a new project. How do you determine which objects have to be exported?

A. Select top level sequencer job and click on "Export" option

B. Select top level sequencer job and click on "Find dependencies" option

C. Select top level sequencer job and click on "Find dependencies (deep)" option

D. Select top level sequencer job and click on "Edit->Job Properties -> Dependencies"