최신IBM Assessment: InfoSphere DataStage v8.5 - A2090-421무료샘플문제
문제1
Which option is required to identify a particular job player processes?Which option is required to identify a particular job? player processes?
Which option is required to identify a particular job player processes?Which option is required to identify a particular job? player processes?
정답: A
문제2
You are asked to convert a relational source, as shown in the exhibit, into three separate XML files. How would you accomplish this task?
You are asked to convert a relational source, as shown in the exhibit, into three separate XML files. How would you accomplish this task?
정답: A
문제3
What three types of links are supported by the Lookup Stage? (Select three)
What three types of links are supported by the Lookup Stage? (Select three)
정답: A,D,E
설명: (ExamPassdump 회원만 볼 수 있음)
문제4
In the exhibit, a Funnel stage has two input links. Input 1 (Seq_File) comes from a SequentialFile with "Readers per Node" set to "2". Input 2 (Dataset) comes from a dataset created with 3 partitions. With the Funnel stage, the funnel type is set to "Sequence". The parallel configuration file contains three nodes.
How many instances of the Funnel stage run in parallel?
In the exhibit, a Funnel stage has two input links. Input 1 (Seq_File) comes from a SequentialFile with "Readers per Node" set to "2". Input 2 (Dataset) comes from a dataset created with 3 partitions. With the Funnel stage, the funnel type is set to "Sequence". The parallel configuration file contains three nodes.
How many instances of the Funnel stage run in parallel?
정답: D
문제5
You have a DataStage job on SMP environment. It contains an input sequential file, a Modify stage, followed by a Transformer stage, and an output Sequential File stage. The job is run with three nodes. The engine uses all default settings. How many processes will this job create?
You have a DataStage job on SMP environment. It contains an input sequential file, a Modify stage, followed by a Transformer stage, and an output Sequential File stage. The job is run with three nodes. The engine uses all default settings. How many processes will this job create?
정답: C
문제6
DataStage offers database connectivity through connectors, native parallel and plug-in stage types. Which two statements are correct? (Choose two.)
DataStage offers database connectivity through connectors, native parallel and plug-in stage types. Which two statements are correct? (Choose two.)
정답: A,B
문제7
Which three of the following are valid options for the dsjob command? (Choose three.)
Which three of the following are valid options for the dsjob command? (Choose three.)
정답: C,D,E
문제8
You would like to pass values into parameters that will be used in a variety of downstream activity stages within a job sequence. What are three valid ways to do this? (Choose three.)
You would like to pass values into parameters that will be used in a variety of downstream activity stages within a job sequence. What are three valid ways to do this? (Choose three.)
정답: B,C,E
문제9
Which two statements are accurate regarding usage of database stages? (Choose two.)
Which two statements are accurate regarding usage of database stages? (Choose two.)
정답: C,D
문제10
Which two property areas must be configured when using the ODBC connector stage as a target in your job design? (Choose two.)
Which two property areas must be configured when using the ODBC connector stage as a target in your job design? (Choose two.)
정답: C,D
문제11
You are asked by your customer to collect partition level runtime meta-data for DataStage Parallel jobs. You must collect this data after each job completes. What two options allow you to automatically save row counts and CPU time for each instance of an operator? (Select two)
You are asked by your customer to collect partition level runtime meta-data for DataStage Parallel jobs. You must collect this data after each job completes. What two options allow you to automatically save row counts and CPU time for each instance of an operator? (Select two)
정답: B,D
문제12
In the job fragment shown in the exhibit, there are two Sort stages: the first (Sort1) sorts the data by state, the second (Sort2) sorts the data by state and area, No repartitioning occurs between the stages.
You have been asked to reduce the number of sorts to improve the performance of the job.
Which two ways might be used to accomplish this without changing how the job functions? (Select two)
In the job fragment shown in the exhibit, there are two Sort stages: the first (Sort1) sorts the data by state, the second (Sort2) sorts the data by state and area, No repartitioning occurs between the stages.
You have been asked to reduce the number of sorts to improve the performance of the job.
Which two ways might be used to accomplish this without changing how the job functions? (Select two)
정답: A,C
문제13
You are working on a project that contains a large number of jobs contained in many folders. You would like to review the jobs created by the former developer of the project. How can you find these jobs?
You are working on a project that contains a large number of jobs contained in many folders. You would like to review the jobs created by the former developer of the project. How can you find these jobs?
정답: D
문제14
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?
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?
정답: D