C2090-424 Online Practice Questions and Answers

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

Which type of data can be extracted using the Unstructured Data stage?

A. XML data

B. Microsoft Word data

C. Microsoft Excel data

D. BigInsights HDFS file data

Given this configuration file: Which of the following describes the resulting behavior for a job consisting of Row Generator -> data set?

A. Conductor, section leader and player processes are executed on the server is1 and is2.

B. Conductor process is executed on the server is1. Section leader and Player processes are executed on the server is2.

C. Conductor and section leader processes are executed on the server is1. Player processes are executed on the server is2.

D. Conductor process and player processes are executed on the server is1. Section leader process is executed on the server is2.

Which of the following is TRUE about Transformer Stage when $APT_TRANSFORM_COMPILE_OLD_NULL_HANDLING is set?

A. A Modify Operator is inserted at run time before a Transformer stage to handle null values

B. If an input column that is used in the derivation expression of an output column contains a null value, then the resulting output column contains a null.

C. If an input column that is used in the derivation expression of an output column contains a null value, then that row will be dropped or, if a reject link had been defined, rejected

D. If an input column that is used in the derivation expression of an output column contains a null value, then the resulting output column will be calculated ignoring the Null value.

Which of the following is the default data type for the Aggregator stage during calculation?

A. Integer

B. Double

C. VarChar

D. Decimal

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

When building an UPDATE statement in SQL Query builder, which of the following is TRUE?

A. Predicates cannot refine what rows are updated

B. Table(s) referenced must have table definitions imported previously

C. Column values can be job parameters or input columns but not expressions

D. Columns to update must be selected individually from the column selection grid

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

What COBOL data type is defined by Decimal data within the Complex Flat File stage?

A. COMP

B. COMP-1

C. COMP-2

D. COMP-3

Which of the following is TRUE?

A. The Modify stage can keep or drop records

B. The DB2 Connector stage can have, at most, one input link

C. The Copy stage can be used for implicit data type conversions

D. When runtime column propagation is enabled, you can use output mapping on a stage to rename or drop columns