質問 1：
Which three are supported by the Slowly Changing Dimensions (SCD) stage? (Choose three.)
A. Type one updates to a dimension table.
B. Type two upserts to a dimension table.
C. Type three updates to a dimension table.
D. Type two updates to a dimension table.
E. Inserts into a dimension table.
正解：A,D,E
質問 2：
A DataStage job is sourcing a flat file which contains a VARCHAR field. This field needs to be mapped to a target field which is a date. Which will accomplish this?
A. Use the TimestampFromDateTime function in a Transformer.
B. Use a Column Exporter to perform the type conversion.
C. DataStage handles the type conversion automatically.
D. Use the Modify stage to perform the type conversion.
正解：D
質問 3：
Your job reads from a file using a Sequential File stage running sequentially. You are using a Transformer stage following the Sequential File stage to format the data in some of the columns. What is the default (Auto) partitioning method?
A. Random
B. Hash
C. Round Robin
D. Same
正解：C
質問 4：
A job validates credit card numbers with a reference file using a Join stage and is hash partitioned by card number. Examination of Job Monitor reveals that some partitions process many more rows than others. Assuming adequate hardware resources, which two actions can be used to improve the performance of the job? (Choose two.)
A. Alter the number of partitions in the $APT_CONFIG_FILE.
B. Use Round Robin partitioning on the stream and Entire partitioning on the reference.
C. Add an additional column to the hash keys.
D. Break the input file into multiple files.
正解：A,C
質問 5：
A credit card company has about 10 million unique accounts. The company needs to determine the outstanding balance of each account (Account_id) by aggregating the previous balance with current charges. A multi-node DataStage job with an Aggregator stage is being used to perform this calculation. Which three tasks are required for optimal performance? (Choose three.)
A. Use "Hash" Aggregator method.
B. Use "Hash" partition on Account_id going into the Aggregator stage.
C. Use "Round Robin" partition on Account_id for even distribution of records.
D. Use "Sort" Aggregator method.
E. Sort data on Account_id going into the Aggregator stage.
正解：B,D,E
質問 6：
Which three methods can be used to import metadata from a Web Services Description Language (WSDL) document? (Choose three.)
A. Job Stage Column tab properties entered using "Load" feature
B. Orchestrate Schema Definitions
C. Web Services WSDL Definitions
D. Web Service Function Definitions
E. XML Table Definitions
正解：C,D,E
Which three are supported by the Slowly Changing Dimensions (SCD) stage? (Choose three.)
A. Type one updates to a dimension table.
B. Type two upserts to a dimension table.
C. Type three updates to a dimension table.
D. Type two updates to a dimension table.
E. Inserts into a dimension table.
正解：A,D,E
質問 2：
A DataStage job is sourcing a flat file which contains a VARCHAR field. This field needs to be mapped to a target field which is a date. Which will accomplish this?
A. Use the TimestampFromDateTime function in a Transformer.
B. Use a Column Exporter to perform the type conversion.
C. DataStage handles the type conversion automatically.
D. Use the Modify stage to perform the type conversion.
正解：D
質問 3：
Your job reads from a file using a Sequential File stage running sequentially. You are using a Transformer stage following the Sequential File stage to format the data in some of the columns. What is the default (Auto) partitioning method?
A. Random
B. Hash
C. Round Robin
D. Same
正解：C
質問 4：
A job validates credit card numbers with a reference file using a Join stage and is hash partitioned by card number. Examination of Job Monitor reveals that some partitions process many more rows than others. Assuming adequate hardware resources, which two actions can be used to improve the performance of the job? (Choose two.)
A. Alter the number of partitions in the $APT_CONFIG_FILE.
B. Use Round Robin partitioning on the stream and Entire partitioning on the reference.
C. Add an additional column to the hash keys.
D. Break the input file into multiple files.
正解：A,C
質問 5：
A credit card company has about 10 million unique accounts. The company needs to determine the outstanding balance of each account (Account_id) by aggregating the previous balance with current charges. A multi-node DataStage job with an Aggregator stage is being used to perform this calculation. Which three tasks are required for optimal performance? (Choose three.)
A. Use "Hash" Aggregator method.
B. Use "Hash" partition on Account_id going into the Aggregator stage.
C. Use "Round Robin" partition on Account_id for even distribution of records.
D. Use "Sort" Aggregator method.
E. Sort data on Account_id going into the Aggregator stage.
正解：B,D,E
質問 6：
Which three methods can be used to import metadata from a Web Services Description Language (WSDL) document? (Choose three.)
A. Job Stage Column tab properties entered using "Load" feature
B. Orchestrate Schema Definitions
C. Web Services WSDL Definitions
D. Web Service Function Definitions
E. XML Table Definitions
正解：C,D,E
0 お客様のコメント