IBM IBM Certified Solution Developer A2090-303 Questions & Answers

• Question 11:

  You want to better understand the tsort operators that are inserted into the job flow at runtime. Which environment variable can provide this information?

  A. $OSH_DUMP

  B. $APT_DUMP_SCORE

  C. $APT_STARTUP_STATUS

  D. $APT_PM_PLAYER_MEMORY

  Correct Answer: B

• Question 12:

  A job using a three-node configuration file writes to a target Sequential File stage. The target Sequential File stage has been set to write to two different sequential files. How many instances of the Sequential File stage will run?

  A. One instance.

  B. Two instances.

  C. Three instances.

  D. Four instances.

  Correct Answer: B

• Question 13:

  Each row contains the CustID, ProductID, ProductType and TotalAmount columns. You want to retain the record with the largest value in the TotalAmount column for each CustID and ProductType using a RemoveDuplicates stage. How can this be accomplished?

  A. Hash-partition on CustID. Sort on CustID, ProductType and TotalAmount.

  B. Hash-partition on TotalAmount. Sort on CustID, ProductType and TotalAmount.

  C. Hash-partition on ProductType. Sort on ProductType, CustID and TotalAmount.

  D. Hash-partition on CustID, ProductType and TotalAmount. Sort on CustID, ProductType and TotalAmount.

  Correct Answer: A

• Question 14:

  A job design consists of an input Sequential Files stage, a Sort stage, followed by a Transformer stage and an output Sequential File stage. In the input Sequential Files stage, the "Number of readers per node" property has been set to 3. The job is run on an SMP machine with a configuration file defined with 3 nodes. The $APT_DISABLE_COMBINATION variable is set to True. How many player processes will this job generate?

  A. 6

  B. 8

  C. 10

  D. 12

  Correct Answer: B

• Question 15:

  The data going into the target Sequential File stage is sorted in each partition by the Date field. You want the data in the sequential file to be sorted by Date. Which collection algorithm should you choose in the Sequential File stage?

  A. Auto

  B. Ordered

  C. Sort Merge

  D. Round Robin

  Correct Answer: C

• Question 16:

  A job using a one-node configuration file writes to a target Sequential File stage. The target Sequential File stage has been set to write to three different sequential files. How many instances of the Sequential File stage will run in parallel?

  A. One.

  B. Two.

  C. Three.

  D. The job will abort, because a configuration file with at least three nodes is required.

  Correct Answer: C

• Question 17:

  Two new columns have been deleted from a sequential file that a number of DataStage jobs write to. You have imported a table definition for the changed file. How can you determine what jobs might be affected by this change?

  A. Select the new table definition, right-click, then click on the Where used command.

  B. Select the original table definition, right-click, then click on the Where used command.

  C. Select the original table definition, right-click, then click on the Find dependencies command.

  D. Select the new table definition, right-click, click on the Compare against command, then select original table definition.

  Correct Answer: B

• Question 18:

  What two Information Server tools can be used to create deployment packages for DataStage jobs? (Choose two.)

  A. istool

  B. Information Server Console

  C. Information Server Manager

  D. InfoSphere Metadata Assset Manager

  E. Information Server Web Console - Administration tab

  Correct Answer: AC

• Question 19:

  You have made a copy of your job and made major changes to a job in your project. You now want to identify all the changes that have been made. What task will allow you to identify these changes?

  A. Export the original job to a backup directory.

  B. Export the modified job to the backup directory.

  C. Select the job, then right click Compare against.

  D. Select the job, then right click Cross Project Compare.

  Correct Answer: C

• Question 20:

  You have finished changes to many jobs and shared containers. You must export all of your changes and integrate them into a test project with other objects. What is a way to select the objects you changed for the export?

  A. Sort the jobs by timestamp.

  B. Open Quick Find and select "Types to Find".

  C. Use Multiple Job Compile to locate objects that need to be compiled.

  D. Using the advanced find dialog, specify in the last modified panel, the date range of the jobs, and appropriate user name.

  Correct Answer: D