876 お客様のコメント
質問 1：
Click the Exhibit button.
In the exhibit, you have three jobs: J1,J2,J3. The Job Sequencer compilation option, "Automatically Handle Activities that fail" is checked. Which two methods shown in the
exhibit ensure J1 and J2 finish successfully before J3? (Choose two.)
A. Exhibit D
B. Exhibit B
C. Exhibit C
D. Exhibit A
正解：C,D
質問 2：
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
質問 3：
Which three data types can the ODBC Enterprise stage handle? (Choose three.)
A. SQL_CLOB
B. SQL_TIMESTAMP
C. SQL_BIGINT
D. SQL_SMALLDATETIME
E. SQL_VARBINARY
正解：B,C,E
質問 4：
Which Oracle Enterprise stage read property can be set using db options to tune job performance?
A. transactsize
B. memsize
C. arraysize
D. partitionsize
正解：C
質問 5：
A job design reads from a complex flat file, performs some transformations on the data, and outputs the results to a WISD output stage. What are two ways that parameter values can be passed to this job at run-time? (Choose two.)
A. Change the properties of the information provider and redeploy.
B. Pass the parameter values at the time of the service request.
C. Include the parameter values in the data.
D. Execute a DSSetParam with the values at job execution time.
正解：A,B
質問 6：
When tuning a parallel process, it is necessary to measure the amount of system resources that are used by each instance of a stage. Which two methods enable the collection of CPU time used by each instance of a stage? (Choose two.)
A. Invoke vmstat before the job run and after the job completes.
B. Select the Record job performance data check box from Job Properties.
C. Set the environment variable $APT_PM_PLAYER_TIMING=true.
D. Set the environment variable $DS_MAKE_JOB_REPORT=2.
正解：B,C
Click the Exhibit button.
In the exhibit, you have three jobs: J1,J2,J3. The Job Sequencer compilation option, "Automatically Handle Activities that fail" is checked. Which two methods shown in the
exhibit ensure J1 and J2 finish successfully before J3? (Choose two.)
A. Exhibit D
B. Exhibit B
C. Exhibit C
D. Exhibit A
正解：C,D
質問 2：
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
質問 3：
Which three data types can the ODBC Enterprise stage handle? (Choose three.)
A. SQL_CLOB
B. SQL_TIMESTAMP
C. SQL_BIGINT
D. SQL_SMALLDATETIME
E. SQL_VARBINARY
正解：B,C,E
質問 4：
Which Oracle Enterprise stage read property can be set using db options to tune job performance?
A. transactsize
B. memsize
C. arraysize
D. partitionsize
正解：C
質問 5：
A job design reads from a complex flat file, performs some transformations on the data, and outputs the results to a WISD output stage. What are two ways that parameter values can be passed to this job at run-time? (Choose two.)
A. Change the properties of the information provider and redeploy.
B. Pass the parameter values at the time of the service request.
C. Include the parameter values in the data.
D. Execute a DSSetParam with the values at job execution time.
正解：A,B
質問 6：
When tuning a parallel process, it is necessary to measure the amount of system resources that are used by each instance of a stage. Which two methods enable the collection of CPU time used by each instance of a stage? (Choose two.)
A. Invoke vmstat before the job run and after the job completes.
B. Select the Record job performance data check box from Job Properties.
C. Set the environment variable $APT_PM_PLAYER_TIMING=true.
D. Set the environment variable $DS_MAKE_JOB_REPORT=2.
正解：B,C
Soeda -
これ一冊あれば十分に事足りると私は思いました。付属の過去問題集の自動採点はかなり重宝しますし、しっかり自分で教科書の中身を押さえれば、とても有用なC2090-418参考書になります。