IBM InfoSphere DataStage v8.5 - C2090-421 模擬練習
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
You have a job that reads in Sequential File followed by a Transformer stage. When you run this job, which partitioning method will be used by default?
正解: D
Click the Exhibit button.
The job in the exhibit runs to successful completion with no warnings. However, a validation test identifies that the CUSTOMER_MASTER table is empty. You suspect the cause to be related to the NEW_CUSTOMERS table or a defect in the job. Examining runtime meta-data will help you track down the problem. Which two product features will help you isolate the cause of the problem? (Choose two.)
The job in the exhibit runs to successful completion with no warnings. However, a validation test identifies that the CUSTOMER_MASTER table is empty. You suspect the cause to be related to the NEW_CUSTOMERS table or a defect in the job. Examining runtime meta-data will help you track down the problem. Which two product features will help you isolate the cause of the problem? (Choose two.)
正解: C,D
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)
正解: B,C
What two repositories does the Source Code Control Integration for DataStage and QualityStage serve? (Choose two.)
正解: A,D
Which two statements are true for named node pools? (Select two)
正解: A,C
解説: (PassTest メンバーにのみ表示されます)
A star schema data warehouse consists of four dimension tables and one fact table. How many Slowly Changing Dimensions (SCD) stages will you need in your jobs to update the star schema tables?
正解: C
You have a dataset hash-partitioned and sorted on CustID. You need to create a Sequential File sorted on CustID from this dataset. Which technique is the most appropriate?
正解: C
You have a dataset that is range-partitioned and sorted. Which technique is most efficient to create globally sorted data file?
正解: D
DataStage offers database connectivity through connectors, native parallel and plug-in stage types. Which two statements are correct? (Choose two.)
正解: C,D
What would help debug the run-time environment?
正解: A
Which two statements are accurate regarding usage of database stages? (Choose two.)
正解: B,C
You have been asked to assess the impact of replacing the DB2 Enterprise Stage with the DB2 Connector. You must identify all of the jobs and shared containers that use the DB2 Enterprise Stage.
What two Advanced Find criteria would you set to identify the jobs and containers? (Choose two.)
What two Advanced Find criteria would you set to identify the jobs and containers? (Choose two.)
正解: B,C
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)
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
Which two of the following derivations for an output column named OutCol can be used to generate a unique sequence of integers across multiple partitions?
正解: B
解説: (PassTest メンバーにのみ表示されます)