IBM InfoSphere DataStage v8.5 - C2090-421 Exam Practice Test
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.)
Correct Answer: B,C,D
Vote an answer
Which three statements are true about File Sets? (Choose three.)
Correct Answer: A,C,D
Vote an answer
Which option is required to identify a particular job player processes?Which option is required to identify a particular job? player processes?
Correct Answer: A
Vote an answer
Which Oracle Enterprise stage read property can be set using -dboptions to tune job performance?
Correct Answer: B
Vote an answer
What three types of links are supported by the Lookup Stage? (Select three)
Correct Answer: B,C,D
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
A DataStage job uses an Inner Join to combine data from two source parallel datasets that were written to disk in sort order based on the join key columns. Which two methods could be used to dramatically improve performance of this job? (Choose two.)
Correct Answer: B,D
Vote an answer
Your customer is using Source Code Control Integration for Information server and have tagged artifacts for version 1. You must create a deployment package from the version 1.
Before you create the package you will have to ensure the project is up to date with version 1.
What two things must you do to update the meta-data repository with the artifacts tagged as version 1? (Select two)
Before you create the package you will have to ensure the project is up to date with version 1.
What two things must you do to update the meta-data repository with the artifacts tagged as version 1? (Select two)
Correct Answer: C,D
Vote an answer
You are using the Change Capture stage in your job design to identify changes made to the input link (before image) to obtain the results in the output link. This job will be using a multi-node configuration file when executed. By default, the Change Capture stage produces an output change link with which two characteristics? (Choose two.)
Correct Answer: A,C
Vote an answer
Click the Exhibit button.
These three Sequential Files shown in the exhibit need to be joined. Join_1 is on Columns CustID and OrderID. Join_2 is on CustID and LocationID. What is the most efficient hash partitioning strategy for each link?
These three Sequential Files shown in the exhibit need to be joined. Join_1 is on Columns CustID and OrderID. Join_2 is on CustID and LocationID. What is the most efficient hash partitioning strategy for each link?
Correct Answer: C
Vote an answer
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?
How many instances of the Funnel stage run in parallel?
Correct Answer: C
Vote an answer
A script invokes an update job called "UpdateKeys" via a command line invocation of the dsjob command. The service is to wait for the completion and status of this job before continuing with the rest its tasks. Which three commands would invoke the "UpdateKeys" job in the MigrationProject and wait for its completion status? (Select three)
Correct Answer: A,D,E
Vote an answer
A customer is complaining of poor performance from the job shown in the exhibit, which aggregates and joins on ZIP code. Currently all partitioning is set to "Auto" and sort/partition insertion is allowed.
What would give the best performance improvement for the job?
What would give the best performance improvement for the job?
Correct Answer: B
Vote an answer