IBM Assessment: InfoSphere DataStage v8.5 Sample Questions:

1. Which two properties can be set to read a fixed width sequential file in parallel? (Choose two.)

A) Set the Execution mode to "Parallel".
B) Set the "Number of Readers Per Node" optional property to a value greater than 1.
C) Set the "Read from Multiple Nodes" optional property to a value greater than 1.
D) Set Read Method to "File Pattern".

2. A client needs to process a flat file where a set of values in the import data columns should be treated as Null. What is the best way to handle multiple Null values using a Sequential File stage?

A) On the Input Link format tab, specify a separator character in the dependent Null field value separator property and then use this separator to delimit the null values in the Null field value property. Click here to input option.
B) On the Input Link format tab, specify the null values in double quotes separated by a comma in the Null field value property.
C) On the Output Link format tab, specify a separator character in the dependent Null field value separator property and then use this separator to delimit the null values in the Null field value property.
D) On the Output Link format tab, specify the null values in double quotes separated by a comma in the Null field value property.

3. Which of the following describes a type two update in a Slowly Changing Dimensions (SCD) stage?

A) An update that replaces the existing column value if a specified condition is satisfied.
B) An update that retains the existing column value in a list and adds the new value to the list.
C) An update that overwrites the existing column value.
D) An update the retains the existing column value in an historical row and creates a new row with the new value.

4. What are two advantages of using Runtime Column Propagation (RCP)? (Choose two.)

A) Columns not specifically used in the flow are propagated as if they were.
B) RCP is not a feature of DataStage.
C) Only columns used in the data flow need to be defined.
D) Sequential files don't require schema files when using RCP.
E) Only columns that are defined as VarChar need RCP enabled.

5. A scenario requires selecting only the most recent transactions for each of 2 million unique customers, from a 20 million row DB2 source table containing order history. Which parallel job design would satisfy this functional requirement?

A) Using the DB2 Enterprise stage, select all rows. Perform a unique Sort using customer number and order date sort keys in ascending order.
B) Using the Dynamic Relational stage, use custom SQL to select all DISTINCT customer numbers from the order history table.
C) Select all rows using the ODBC Connector stage, use a Sort Aggregator on customer number key to select the maximum order date.
D) Using the DB2 API stage, select all rows. Use a Sort stage with customer number and order date sort keys in ascending order, then Remove Duplicates with Last Duplicate to retain.

Solutions: