IBM InfoSphere DataStage v8.5 - 000-421 Exam Practice Test
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?
Correct Answer: A
Vote an answer
What is the correct method to process a file containing multiple record types using a Complex Flat File stage?
Correct Answer: D
Vote an answer
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?
Correct Answer: D
Vote an answer
In the job fragment shown in the exhibit, the data going into the target Sequential File stage needs to be sorted by postal code. The Sort stage accomplishes this by running in Sequential mode and sorting by postal code. You have been asked to improve the performance of the job with a 4-node configuration file.
Which two changes will improve the performance of the job? (Choose two.)
Which two changes will improve the performance of the job? (Choose two.)
Correct Answer: B,D
Vote an answer
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
Which condition is required to use the LastRowInGroup() function to determine a key break on a field?
Correct Answer: C
Vote an answer
Your job sequence must be restartable. It runs Job1, Job2, and Job3 serially. It has been compiled with "Add checkpoints so sequence is restartable". Job1 must execute every run even after a failure. Which two properties must be selected to ensure that Job1 is run each time, even after a failure? (Choose two.)
Correct Answer: A,C
Vote an answer
When you configure a domain for source code integration a source control workspace is created. What are two reasons for the source control workspace? (Choose two.)
Correct Answer: A,C
Vote an answer
The derivation for a stage variable is: Upcase(input_column1) : ' ' : Upcase(input_column2). Suppose that input_column1 contains a NULL value. Which behavior is expected?
Correct Answer: B
Vote an answer
A customer requests you to configure a Sequential File stage in a clustered environment. The stage must read a varying number of files each run in a single pass and append the name of the file the row was read from when an error occurs. What three steps are required to achieve this? (Select three)
Correct Answer: A,C,E
Vote an answer
To better understand the data flowing through a job, it is desirable to have structural information about the datasets captured in the job log. Which environment variable can provide this information?
Correct Answer: A
Vote an answer
Which two statements are true about Transformer loop processing? (Select two)
Correct Answer: A,C
Vote an answer
Which two statements are true about DataStage Parallel Build stages? (Choose two.)
Correct Answer: B,C
Vote an answer