IBM InfoSphere DataStage v9.1 Sample Questions:

1. You are asked to optimize the fork join job design in the exhibit. This job uses the sort aggregator and a left outer join on the ZIP code column. Currently all partitioning is set to "Auto" and automatic sort insertion is allowed.

Which change will reduce the cost of partitioning that occurs in this job?

A) Hash partition and sort on ZIP code column prior to the Copy stage, and use same partitioning on the Aggregator and Join stages.
B) Hash partition and sort on ZIP code column on the input links to the Aggregator and Join stages.
C) Hash partition and sort on ZIP code column prior to the Copy stage and use entire partitioning on the Aggregator and Join stages.
D) Use Entire partitioning on the input links to the Aggregator and Join stages.

2. Suppose a user ID has been created with DataStage and QualityStage component authorization. Which client application would be used to give that user ID DataStage Developer permission?

A) DataStage Director client
B) DataStage Administrator client
C) DataStage Designer client
D) Information Server Web Console Administrator client

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

A) Indicate all stage names within the job annotation.
B) Name all stages and links based on what they do.
C) Name all stage and links the same.
D) Name all stage and links with column names and ideas.

4. Which partitioning method requires a key?

A) Round Robin
B) Modulus
C) Sort Merge
D) Same

5. Your job is using the Sequential File stage as a source. Identify two stage property configurations that will allow you to accomplish parallel reads? (Choose two.)

A) Read Method property set to 'Specific File(s)' with only one file specified and the 'Readers Per Node' property value set to greater than 1.
B) Read Method property set to 'File Pattern' and the environment variable $APT_IMPORT_PATTERN_USES_FILESET is set to 'FALSE'.
C) Read Method property is set to 'Parallel' with the Key property set to a Input column that has the file names.
D) Read Method property set to 'Specific File(s)' with more than one file specified and each file specified has the same format/column properties.
E) Read Method property set to 'File Pattern' and the 'Readers per Node' property value set to greater than 1.

Solutions: