IBM IBM Certified Solution Developer A2090-303 Questions & Answers

• Question 31:

  You have created three parallel jobs (Job A, B and C) in which the output of one job is the input to the other job. You are required to create processing that manages this data relationship of the jobs and provide job level restart-ability. What two tasks will accomplish these objectives? (Choose two.)

  A. Enable runtime column propagation for the job sequence running the jobs.

  B. Set the 'Add checkpoints so sequence is restartable' option in the Sequencer job.

  C. Enable the 'Add checkpoints so container is restartable' option for each of the parallel shared containers.

  D. Create two parallel shared containers that has the logic of Job B and Job C and include those shared containers in the correct flow order within the design of Job A.

  E. Create a Sequencer job that has triggered events configured allowing Job A to run first, then Job B to run when A completes successfully, and then Job C to run when Job B completes successfully.

  Correct Answer: BE

• Question 32:

  The effective use of naming conventions means that objects need to be spaced appropriately on the DataStage Designer canvas. For stages with multiple links,expanding the icon border can significantly improve readability. This approach takes extra effort at first, so a pattern of work needs to be identified and adopted to help development. Which feature of Designer can improve development speed?

  A. Palette Layout

  B. Repository Layout

  C. Snap to Grid Feature

  D. Show Performance Statistics Feature

  Correct Answer: C

• Question 33:

  What two project environment variables can be considered in your parallel jobs to support your optimization strategy of partitioning and sorting? (Choose two.)

  A. $APT_NO_PART_INSERTION

  B. $APT_OPT_SORT_INSERTION

  C. $APT_RESTRICT_SORT_USAGE

  D. $APT_PARTITION_FLUSH_COUNT

  E. $APT_TSORT_STRESS_BLOCKSIZE

  Correct Answer: AE

• Question 34:

  What is used to configure the DataStage QualityStage Operations Console?

  A. DataStage Administrator

  B. The DSODBCConfig.cfg file

  C. The DSAppWatcher.sh script

  D. Information Server Web Console

  Correct Answer: B

• Question 35:

  Which statement is true about Information Server logging?

  A. Multiple configurations can be active at the same time.

  B. Severity levels specify the threshold for saving events in the metadata repository.

  C. You can activate or de-activate the logging configuration in DataStage Administrator.

  D. You must log into the Information Server Web Console as a DataStage administrator in order to configure logging.

  Correct Answer: B

• Question 36:

  You are editing the configuration file. Which statement is true about file system efficiency?

  A. Using multiple scratch spaces in a logical node improves performance.

  B. For the resource disk, it is best to use the partition where the engine is installed.

  C. Creating scratch disk spaces on an internal disk rather than on an NFS drive improves sort performance.

  D. In a clustered environment where NAS is used for a common storage, you must specify the internal disk for scratch disk.

  Correct Answer: C

• Question 37:

  Which statement is true about creating DataStage projects?

  A. DataStage projects cannot be created during DataStage installation.

  B. After installation only DataStage developers can create DataStage projects.

  C. After installation DataStage projects can be created in DataStage Administrator.

  D. After installation DataStage projects can be created in the Information Server Web Console.

  Correct Answer: C

• Question 38:

  What are the valid join operations for the Join stage? (Choose two.)

  A. Inner join

  B. Where join

  C. Top outer join

  D. Right outer join

  E. Bottom inner join

  Correct Answer: AD

• Question 39:

  How must the input data set be organized for input into the Join stage? (Choose two.)

  A. Unsorted

  B. Key partitioned

  C. Hash partitioned

  D. Entire partitioned

  E. Sorted by Join key

  Correct Answer: BE

• Question 40:

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

  A. Disable job monitoring.

  B. Set the environment variable $APT_SORT_INSERTION_CHECK_ONLY.

  C. Unset the Preserve Partitioning flag on the output of each parallel dataset.

  D. Explicitly specify hash partitioning and sorting on each input to the Join stage.

  E. Add a parallel sort stage before each Join input, specifying the "Don't Sort, Previously Grouped" sort key mode for each key.

  Correct Answer: BE