C2090-424 Online Practice Questions and Answers

What is the primary advantage of creating data rules within Information Analyzer as opposed to creating them within the Data Rules stage?

A. Data rules cannot be created within the Data Rules stage. They must first be created in Information Analyzer before they can be used in the Data Rules stage.

B. Rules created within Information Analyzer can be tested and debugged on non-operational data in a testing environment before they are put into production.

C. Rules created in the DataStage Data Rules stage have to be compiled into an executable form before they can be used.

D. The variables in rules created in DataStage Data Rules stage must first be bound to data columns or literals before they can be run.

Which of the following actions are available when editing a message handler?

A. Abort Job

B. Demote to warning

C. Promote to warning

D. Promote to informational

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 is TRUE about Balanced Optimization?

A. Balanced Optimization is installed with InfoSphere DataStage.

B. Balanced Optimization creates a parameter set called BalOpJAQLParams in the underlying project if it does not exist.

C. Balanced Optimization will change or optimize machine configurations, InfoSphere DataStage configurations, database configurations, or HDFS configurations.

D. Balanced optimizations are performed in a priority order. When there is ambiguity (for example, some

processing could be performed either in a source or target database) processing is pushed into database sources.

Which of the following environment variables can help in verifying whether data is evenly partitioned across all nodes?

A. $OSH_PRINT_SCHEMAS

B. $APT_RECORD_COUNTS

C. $APT_PARTITION_COUNT

D. $APT_DEBUG_OPERATOR

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.

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 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 encrypt.sh or the encrypt.bat script can be used to do which of the following?

A. Secure sensitive personal data

B. To set up credentials files used by the dsjob command

C. Assisting in decoding encrypted rows of input during debugging

D. Assisting in preparing encrypted rows of output during job execution

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