IBM InfoSphere DataStage v11.3 認定 C2090-424 試験問題:
1. Which one of the following stages requires a schema file when using Runtime Column Propagation?
A) Data Set Stage
B) Modify Stage
C) Sequential File Stage
D) Transformer Stage
2. The encrypt.sh or the encrypt.bat script can be used to do which of the following?
A) Assisting in decoding encrypted rows of input during debugging
B) Secure sensitive personal data
C) To set up credentials files used by the dsjob command
D) Assisting in preparing encrypted rows of output during job execution
3. A job is designed with 3 Join stages in sequence.
Join_1 keys are "Account", "Customer" and "PO_Date"
Join_2 keys are "Account", "Customer" and "Txn"
Join_3 keys are "Account", "Product_CD" and "Txn"
Which of the following will lead to the best run time performance?
A) Both left and right links are Hash partitioned as follows:
Join_1 by "Account", "Customer" and "PO_Date"
Join_2 by "Account", "Customer" and "Txn"
Join_3 by "Account", "Product_CD" and "Txn"
B) Both left and right links are Hash partitioned as follows:
Join_1 by "Account" and "Customer"
Join_2 by "Account" and "Customer"
Join_3 by "Account"
C) Left links are Hash partitioned on "Account" for the first two joins and on "Product_CD" for the third.
Right links are Hash partitioned on "Account" for all joins
D) Left links are Hash partitioned on "Account" for all joins Right links are Hash partitioned on "Account" for all joins
4. 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) The variables in rules created in DataStage Data Rules stage must first be bound to data columns or literals before they can be run.
C) Rules created in the DataStage Data Rules stage have to be compiled into an executable form before they can be used.
D) Rules created within Information Analyzer can be tested and debugged on non-operational data in a testing environment before they are put into production.
5. Which of the following is NOT a valid use of stage variables?
A) Storing values that can be referenced by name in downstream stages
B) Storing values from one row to compare with values in the next row read
C) Storing values to be used in both derivations and constraints
D) Storing the result on an expression to be used in multiple output columns
質問と回答:
質問 # 1 正解: C | 質問 # 2 正解: D | 質問 # 3 正解: D | 質問 # 4 正解: D | 質問 # 5 正解: D |