718 お客様のコメント
質問 1：
You have developed a parallel job using best practices to include Copy stages as debugging placeholders. In the parallel job score for this job, you notice that some of the Copy stages are not being optimized out as you had expected. What are three reasons for this behavior? (Choose three.)
A. The environment variable $APT_DISABLE_COPY_OPTIMIZATION has been set.
B. The "Force" property was set to "true" for one of the Copy stages.
C. One Copy stage has multiple outputs.
D. A non-default node pool was assigned to one of the Copy stages.
E. Runtime Column Propagation has been enabled on one or more of the Copy output links.
正解：B,C,D
質問 2：
You are assigned to correct a job from another developer. The job contains 20 stages sourcing data from two Data Sets and many sequential files. The annotation in the job indicates who wrote the job and when, not the objective of the job. All link and stage names use the default names. One of the output columns has an incorrect value which should have been obtained using a lookup. What could the original developer have done to make this task easier for maintenance purposes?
A. Name all stages and links based on what they do.
B. Name all stage and links with column names and ideas.
C. Indicate all stage names within the job annotation.
D. Name all stage and links the same.
正解：A
質問 3：
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. Change the Auto-purge settings in Administrator.
D. Set the $APT_AUTOLOG_PURGE environment variable to False.
正解：A
質問 4：
You have created a new parallel routine that has custom date conversion logic to support a column named "TrnCharPtrnDt". You use a Table Definition named "TrnSrcSys" forall jobs accessing this as a source. What are two ways you can locate the jobs that may need to be considered for using this parallel routine? (Choose two.)
A. In Designer use the Repository Advanced Find functionality with the "Where used" option for an object named "TrnCharPtrnDt".
B. In Designer select the "TrnSrcSys" object in the Repository window and choose the "Find Where used" option.
C. In Manager use the Repository Advanced Find functionality with the "Where used" option for an object named "TrnCharPtrnDt".
D. In Designer select the Jobs category and choose "Job Search" option to locate the value "*Date".
正解：A,B
質問 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：
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
You have developed a parallel job using best practices to include Copy stages as debugging placeholders. In the parallel job score for this job, you notice that some of the Copy stages are not being optimized out as you had expected. What are three reasons for this behavior? (Choose three.)
A. The environment variable $APT_DISABLE_COPY_OPTIMIZATION has been set.
B. The "Force" property was set to "true" for one of the Copy stages.
C. One Copy stage has multiple outputs.
D. A non-default node pool was assigned to one of the Copy stages.
E. Runtime Column Propagation has been enabled on one or more of the Copy output links.
正解：B,C,D
質問 2：
You are assigned to correct a job from another developer. The job contains 20 stages sourcing data from two Data Sets and many sequential files. The annotation in the job indicates who wrote the job and when, not the objective of the job. All link and stage names use the default names. One of the output columns has an incorrect value which should have been obtained using a lookup. What could the original developer have done to make this task easier for maintenance purposes?
A. Name all stages and links based on what they do.
B. Name all stage and links with column names and ideas.
C. Indicate all stage names within the job annotation.
D. Name all stage and links the same.
正解：A
質問 3：
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. Change the Auto-purge settings in Administrator.
D. Set the $APT_AUTOLOG_PURGE environment variable to False.
正解：A
質問 4：
You have created a new parallel routine that has custom date conversion logic to support a column named "TrnCharPtrnDt". You use a Table Definition named "TrnSrcSys" forall jobs accessing this as a source. What are two ways you can locate the jobs that may need to be considered for using this parallel routine? (Choose two.)
A. In Designer use the Repository Advanced Find functionality with the "Where used" option for an object named "TrnCharPtrnDt".
B. In Designer select the "TrnSrcSys" object in the Repository window and choose the "Find Where used" option.
C. In Manager use the Repository Advanced Find functionality with the "Where used" option for an object named "TrnCharPtrnDt".
D. In Designer select the Jobs category and choose "Job Search" option to locate the value "*Date".
正解：A,B
質問 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：
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
真木** -
私はC2090-418問題集を利用したら、試験に合格できると信じています。案の定、いい成績で試験に合格しました。ありがとうございました。