897 お客様のコメント
質問 1：
Consider a Parallel Job including a Join Stage with HASH partitioning algorithm followed by an Aggregator stage. Which of the following statements about the Aggregator stage partition algorithm is correct?about the Aggregator stage? partition algorithm is correct?
A. If the Aggregator groups on the same key column(s) as Join, repartitioning must be done in order to have correct results
B. If the Aggregator groups on the same key column(s) as Join, SAME ensures groups of rows stays together
C. ROUND ROBIN ensures correct results
D. If the Aggregator groups on different key column(s) from Join, SAME ensures groups of rows stay together
正解：B
質問 2：
Which of the following is a valid Write Table action in the Connector Stages?
A. Replace
B. All of the above
C. Truncate
D. Append
正解：B
質問 3：
What are the file format types when you use DataStage Designer to export objects?
A. DSX and CSV
B. TXT and CSV
C. DSX and XML
D. TXT and XML
正解：C
質問 4：
In DataStage, Table Definitions can be imported through __________.
A. Information Server Web Console
B. DataStage Director
C. DataStage Administrator
D. DataStage Designer
正解：D
質問 5：
Which of the following is NOT a function provided by the DB2 Connector Stage?
A. Reads a DB2 table
B. Deletes rows from a DB2 table
C. Performs a lookup directly on a DB2 table
D. Automatically updates table definitions when a SQL type mismatch is detected
正解：D
質問 6：
Which of the following statements about FastTrack is incorrect?
A. When generating a job from a FastTrack specification, you can specify the desired stage type for the source and the target (e.g. sequentialfile, ODBC connector, DB2 connector)
B. Changes in mapping specifications are propagated to previously generated DataStage jobs as annotations
C. When a job is generated from a FastTrack specification, it can contain connection information to access source and target database systems
D. The only way to combine data in a FastTrack mapping specification is to create a lookup definition
正解：D
Consider a Parallel Job including a Join Stage with HASH partitioning algorithm followed by an Aggregator stage. Which of the following statements about the Aggregator stage partition algorithm is correct?about the Aggregator stage? partition algorithm is correct?
A. If the Aggregator groups on the same key column(s) as Join, repartitioning must be done in order to have correct results
B. If the Aggregator groups on the same key column(s) as Join, SAME ensures groups of rows stays together
C. ROUND ROBIN ensures correct results
D. If the Aggregator groups on different key column(s) from Join, SAME ensures groups of rows stay together
正解：B
質問 2：
Which of the following is a valid Write Table action in the Connector Stages?
A. Replace
B. All of the above
C. Truncate
D. Append
正解：B
質問 3：
What are the file format types when you use DataStage Designer to export objects?
A. DSX and CSV
B. TXT and CSV
C. DSX and XML
D. TXT and XML
正解：C
質問 4：
In DataStage, Table Definitions can be imported through __________.
A. Information Server Web Console
B. DataStage Director
C. DataStage Administrator
D. DataStage Designer
正解：D
質問 5：
Which of the following is NOT a function provided by the DB2 Connector Stage?
A. Reads a DB2 table
B. Deletes rows from a DB2 table
C. Performs a lookup directly on a DB2 table
D. Automatically updates table definitions when a SQL type mismatch is detected
正解：D
質問 6：
Which of the following statements about FastTrack is incorrect?
A. When generating a job from a FastTrack specification, you can specify the desired stage type for the source and the target (e.g. sequentialfile, ODBC connector, DB2 connector)
B. Changes in mapping specifications are propagated to previously generated DataStage jobs as annotations
C. When a job is generated from a FastTrack specification, it can contain connection information to access source and target database systems
D. The only way to combine data in a FastTrack mapping specification is to create a lookup definition
正解：D
针谷** -
この問題集はP2090-045試験の出題範囲を完全分析・網羅したテキストでして、本当に使ってみて最高って思いました。
三日前に試験に受けて、無事合格でした。IBMさんあざっす。