IBM InfoSphere DataStage v8.5 Sample Questions:

1. You are about to begin major changes to jobs in a project. You want to conveniently identify job changes on an ad hoc basis. What two tasks will allow you to identify changes to your jobs? (Choose two.)

A) Before making a change to a job make a copy of the job in a different category folder.
B) Select the job, then right click Compare within.
C) Select the job, then right click Cross Project Compare.
D) Import the original job from a .dsx export.

2. You are experiencing performance issues for a given job. You are assigned the task of understanding what is happening at run time for that job. What are the first two steps you should take to understand the job performance issues? (Choose two.)

A) Run job with $APT_DUMP_SCORE set to true.
B) Run job with $APT_TRACE_RUN set to true.
C) Replace Transformer stages with custom operators.
D) Review the objectives of the job.

3. 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.)

A) Eliminate the existing Sort stage; define an in-stage sort in the Filter stage, sorting by postal code. In the target Sequential File stage choose the SortMerge collector.
B) Move the Sort stage in front of the Filter stage, so that the sort is performed earlier in the job.
C) Add a second Sort stage just before the existing Sort stage; run the new stage in parallel mode sorting by postal code.
D) Change the mode of the existing Sort stage to parallel mode; continue to sort by postal code. In the target Sequential File stage choose the SortMerge collector.

4. 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) You must use APT_PM_CONDUCTOR_HOSTNAME variable for optimal environment.
B) Using the host names on the private network for 'fastname' makes better performance.
C) The client machines on the public network must use the host name for the engine on the private network to connect.
D) Host name alias is not allowed for conductor node.

5. How does the Complex Flat File stage (CFF) support the use of "OCCURS DEPENDING ON" clause?

A) The related elements are output as arrays.
B) CFF does not support this clause.
C) The related elements are output as subrecords.
D) The related elements are output as denormalized fields.

Solutions: