861 お客様のコメント
質問 1：
You have been asked to delete a shared container from the project by your customer. Before you do this you want to make sure it will not impact other objects in the project. How will you ensure that deleting the shared container will not cause a failure when jobs are recompiled?
A. Select the shared container, Right-click on the Where used command.
B. Select the shared container, Right-click on the Where used (deep) command.
C. Select the shared container, Right-click on the Dependencies (deep) command.
D. Advanced find, set Dependencies Of field equal to the container name, and Check the Option to Include nested results for Dependency searches.
正解：B
質問 2：
Which two statements about annotations are correct? (Select two)
A. The Short job description field will appears in job log when $APT_PM_SHOW_PIDS is set.
B. The Short job description field displays on log summary lines within Director client.
C. An annotation can be drawn around one of more stages.
D. The Full job description field is only visible within the Designer Client.
正解：A,C
質問 3：
You are setting up a clustered environment. Each node in the cluster has public and private network adapters. The private network uses fast Ethernet. Which two statements are true? (Select two)
A. Host name alias is not allowed for conductor node.
B. You must use APT_PM_CONDUCTOR_HOSTNAME variable for optimal environment.
C. The client machines on the public network must use the host name for the engine on the private network to connect.
D. Using the host names on the private network for 'fastname' makes better performance.
正解：B,D
質問 4：
Which three statements are true about characteristics of shared containers? (Select three)
A. Containers are a group of stages and links.
B. Containers allow you to implement recurring logic.
C. Containers allow multiple users to access a single job.
D. Containers allow you to provide pre-configured job design logic.
E. Containers are used to execute jobs.
正解：A,B,E
解説: (Pass4Test メンバーにのみ表示されます)
質問 5：
If you do not alter any of the Format settings, the Sequential File stage will produce a file with what three types of format? (Choose three.)
A. Rows are delimited by a DOS newline.
B. All columns are delimited by a comma.
C. Variable length columns are contained within double quotes.
D. All columns are delimited by a comma, except for the final column in a row.
E. Rows are delimited by a UNIX newline.
正解：C,D,E
質問 6：
What is the lowest CPU cost partitioning method?
A. Random
B. Hash
C. Round Robin
D. Entire
正解：C
質問 7：
In the exhibit, the Aggregator stage aggregates over CustomerID. The Join stage joins by CustomerID. When the score is created, DataStage will insert hash partitioners and tsort operators to ensure the correct results.
Which two choices will eliminate sort operators from being inserted at run-time? (Select two)
A. Add Sort stages in front of the Join stage and specify the Same partitioner for the links going into the Join. Set the $APT_NO_SORT_INSERTION environment variable to "True".
B. Add a Sort stage before the Copy stage and specify Same partitioners for the links going into the Aggregator and Join stages.
C. Add a Sort stage before the Aggregator stage and specify the Same partitioner for the link going into the Aggregator Set the $APT_SORTJNSERTION_CHECK_ONLY environment variable to "True".
D. Add a Sort stage before the Copy stage and specify Auto partitioned for the links going into the Aggregator and Join stages.
正解：A,B
You have been asked to delete a shared container from the project by your customer. Before you do this you want to make sure it will not impact other objects in the project. How will you ensure that deleting the shared container will not cause a failure when jobs are recompiled?
A. Select the shared container, Right-click on the Where used command.
B. Select the shared container, Right-click on the Where used (deep) command.
C. Select the shared container, Right-click on the Dependencies (deep) command.
D. Advanced find, set Dependencies Of field equal to the container name, and Check the Option to Include nested results for Dependency searches.
正解：B
質問 2：
Which two statements about annotations are correct? (Select two)
A. The Short job description field will appears in job log when $APT_PM_SHOW_PIDS is set.
B. The Short job description field displays on log summary lines within Director client.
C. An annotation can be drawn around one of more stages.
D. The Full job description field is only visible within the Designer Client.
正解：A,C
質問 3：
You are setting up a clustered environment. Each node in the cluster has public and private network adapters. The private network uses fast Ethernet. Which two statements are true? (Select two)
A. Host name alias is not allowed for conductor node.
B. You must use APT_PM_CONDUCTOR_HOSTNAME variable for optimal environment.
C. The client machines on the public network must use the host name for the engine on the private network to connect.
D. Using the host names on the private network for 'fastname' makes better performance.
正解：B,D
質問 4：
Which three statements are true about characteristics of shared containers? (Select three)
A. Containers are a group of stages and links.
B. Containers allow you to implement recurring logic.
C. Containers allow multiple users to access a single job.
D. Containers allow you to provide pre-configured job design logic.
E. Containers are used to execute jobs.
正解：A,B,E
解説: (Pass4Test メンバーにのみ表示されます)
質問 5：
If you do not alter any of the Format settings, the Sequential File stage will produce a file with what three types of format? (Choose three.)
A. Rows are delimited by a DOS newline.
B. All columns are delimited by a comma.
C. Variable length columns are contained within double quotes.
D. All columns are delimited by a comma, except for the final column in a row.
E. Rows are delimited by a UNIX newline.
正解：C,D,E
質問 6：
What is the lowest CPU cost partitioning method?
A. Random
B. Hash
C. Round Robin
D. Entire
正解：C
質問 7：
In the exhibit, the Aggregator stage aggregates over CustomerID. The Join stage joins by CustomerID. When the score is created, DataStage will insert hash partitioners and tsort operators to ensure the correct results.
Which two choices will eliminate sort operators from being inserted at run-time? (Select two)
A. Add Sort stages in front of the Join stage and specify the Same partitioner for the links going into the Join. Set the $APT_NO_SORT_INSERTION environment variable to "True".
B. Add a Sort stage before the Copy stage and specify Same partitioners for the links going into the Aggregator and Join stages.
C. Add a Sort stage before the Aggregator stage and specify the Same partitioner for the link going into the Aggregator Set the $APT_SORTJNSERTION_CHECK_ONLY environment variable to "True".
D. Add a Sort stage before the Copy stage and specify Auto partitioned for the links going into the Aggregator and Join stages.
正解：A,B
川村** -
C2090-421合格しました。
実際の試験はほとんど模試で学習した通りの内容でした。
きちんと学習して本番に臨めば大丈夫です。
ありがとうございました。