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 stages will require a schema file when runtime column propagation (RCP) is enabled? (Choose two.)

A. Data Set

B. Column Import

C. Internal Source

D. External Target

E. Make Subrecord

To run multiple copies of the same job within Director, which of the following must be supplied?

A. Job name

B. Invocation ID

C. Parameter values

D. Username and password

Which of the following is TRUE about working with assets and artifacts?

A. Rational Team Connect is not supported at all

B. Information Server Manager has no logging capability

C. You cannot lock and unlock assets in Rational Team Concert, regardless of tool used

D. You must import the source control project into your own source control workspace in Information Server Manager before you can submit assets

How do you create a shared table definition from the DataStage client?

A. Use the save button on the columns tab of the stage editor

B. Use the shared table creation wizard from the repository window

C. Do nothing. They are created automatically when table definitions are imported

D. It cannot be done within the DataStage client. Use the InfoSphere Metadata Asset Manager (IMAM) utility instead.

You want to retain the record with the largest value in the TotalAmount column for each CustID and ProductType using a Remove Duplicates stage. How can this be accomplished?

A. Hash partition on TotalAmount. Sort on CustID, ProductType and TotalAmount

B. Hash partition on ProductType. Sort on CustID, ProductType and TotalAmount

C. Hash partition on CustID and ProductType. Sort on CustID, ProductType and TotalAmount

D. Hash partition on CustID, ProductType and TotalAmount. Sort on CustID, ProductType and TotalAmount

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

By default, how much internal memory does the Sort use per partition?

A. 10MB

B. 20MB

C. 25MB

D. 30MB

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