InfoSphere DataStage v11.3: C2090-424

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.

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

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