IBM Assessment: InfoSphere DataStage v8.5 認定 A2090-421 試験問題:

1. How does the Complex Flat File stage (CFF) support the use of "OCCURS DEPENDING ON" clause?

A) The related elements are output as subrecords.
B) The related elements are output as denormalized fields.
C) The related elements are output as arrays.
D) CFF does not support this clause.

2. Which Oracle data type conversion is correct?

A) Oracle data type NUMBER converts to DECIMAL(38, 0) in Oracle Enterprise stage.
B) Oracle data type NUMBER(15, 0) converts to INT32 in Oracle Enterprise stage.
C) Oracle data type RAW converts to RAW in Oracle Enterprise stage.
D) Oracle data type NUMBER(6, 0) converts to INT32 in Oracle Enterprise.

3. Which two statements are correct about XML stages and their usage? (Choose two.)

A) XML Input stage transforms hierarchical XSLT data to tabular format.
B) XML Output stage converts relational tables and sequential files to XML hierarchical structures.
C) XML Input stage converts XML data to hierarchical format.
D) XML Transformer stage converts an XML document to another XML hierarchical format.

4. A DataStage job uses an Inner Join to combine data from two source parallel datasets that were written to disk in sort order based on the join key columns. Which two methods could be used to dramatically improve performance of this job? (Choose two.)

A) Disable job monitoring.
B) Explicitly specify hash partitioning and sorting on each input to the Join stage.
C) Unset the Preserve Partitioning flag on the output of each parallel dataset.
D) Set the environment variable $APT_SORT_INSERTION_CHECK_ONLY.
E) Add a parallel sort stage before each Join input, specifying the "Don't Sort, Previously Grouped" sort key mode for each key.

5. You are required to use a Make Vector stage in your job. What three requirements must be met in order to use this stage? (Choose three.)

A) Input columns must form a numeric sequence.
B) Columns must be in consecutive order.
C) All columns are combined into a vector of the same length as the number of columns.
D) Input columns that do not have a name of form <column_name>0 to <column_name>n, where <column_name> is the column name and 0 and n are the first and last of its consecutive numbers will not be included in the vector and will be dropped.
E) Input columns must all be of the same data type.

質問と回答：