IBM 000-421 問題集

質問 1：
What are two advantages of using Runtime Column Propagation (RCP)? (Choose two.)
A. Only columns that are defined as VarChar need RCP enabled.
B. RCP is not a feature of DataStage.
C. Only columns used in the data flow need to be defined.
D. Columns not specifically used in the flow are propagated as if they were.
E. Sequential files don't require schema files when using RCP.
正解：C,D

質問 2：
A customer must compare a date column with a job parameter date to determine which output links the row belongs on. What stage should be used for this requirement?
A. Transformer stage
B. Compare stage
C. Switch stage
D. Filter stage
正解：A

質問 3：
Records in a source file must be copied to multiple output streams for further processing. Which two conditions would require the use of a Transformer stage instead of a Copy stage? (Choose two.)
A. Converting some input columns from integers to strings.
B. Renaming one or more output columns.
C. Directing selected output records down one output link rather than another.
D. Concatenating data from multiple input columns.
正解：C,D

質問 4：
Which two properties can be set to read a fixed width sequential file in parallel? (Choose two.)
A. Set Read Method to "File Pattern".
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 the Execution mode to "Parallel".
正解：B,C

質問 5：
Which two tasks can the Slowly Changing Dimensions (SCD) stage perform? (Choose two.)
A. Look up whether a record with a matching business key value exists in a fact table. If it does not, retrieve a new surrogate key value and insert a new row into the fact table.
B. Look up whether a record with a matching business key value exists in a dimension table. If it does not, retrieve a new surrogate key value and insert a new row into the dimension table.
C. Look up whether a record with a matching business key value exists in a dimension table. If it does, mark the record as not-current, and generate a new record with new values for selected fields.
D. Look up whether a record with a matching business key value exists in a dimension table. If it does, add new values for selected fields to values lists for those fields.
正解：B,C

質問 6：
What is the correct method to process a file containing multiple record types using a Complex Flat File stage?
A. Define record ID constraints on the Records ID tab of the Complex Flat File stage.
B. Use a Modify stage to convert the output array from the Complex Flat File to a subrecord.
C. Define record definitions on the Constraints tab of the Complex Flat File stage.
D. Manually break the file into multiple files by record type.
正解：A

質問 7：
What is the lowest CPU cost partitioning method?
A. Entire
B. Hash
C. Random
D. Round Robin
正解：D

質問 8：
You have run ten instances of the same job the previous evening. You want to examine the job logs for all instances but can only find five of them. How can you avoid this in the future for this job?
A. Change the Auto-purge settings for the job in Director.
B. Set the $APT_AUTOPURGE_LOG environment variable to False.
C. Set the $APT_AUTOLOG_PURGE environment variable to False.
D. Change the Auto-purge settings in Administrator.
正解：A

質問 9：
How are Shared Table definitions created from the DataStage Client?
A. Using the "Shared Table Creation Wizard" from the DataStage Client.
B. Using the "Save" button on the "Table Properties" panel
C. No need to, DataStage table definitions are automatically saved as shared metadata.
D. This cannot be done from the DataStage Client
E. Using the "Save" button on the columns tab on the Stage/Link editor
正解：A