IBM IBM Certified Solution Developer A2090-303 Questions & Answers

• Question 111:

  In addition to the table and schema names, what two element names must be specified when you create a shared table definition in DataStage Designer? (Choose two.)

  A. Database

  B. Host system

  C. Project name

  D. Database instance

  E. DataStage server system name

  Correct Answer: AB

• Question 112:

  Which option is required to identify a particular job player processes?Which option is required to identify a particular job? player processes?

  A. Set $APT_DUMP_SCORE to true.

  B. Set $APT_PM_SHOW_PIDS to true.

  C. Log onto the server and issue the command "ps -ef | grep ds".

  D. Use the DataStage Director Job administration screen to display active player processes.

  Correct Answer: B

• Question 113:

  How is DataStage table metadata shared among DataStage projects?

  A. Import another copy of the table metadata into the project where it is required.

  B. Use the "Shared Table Creation Wizard" to place the table in the shared repository.

  C. Export DataStage table definitions from one project and importing them into another project.

  D. Use the InfoSphere Metadata Asset Manager (IMAM) to move the DataStage table definition to the projects where it is needed.

  Correct Answer: B

• Question 114:

  You are asked by your customer to collect partition level runtime metadata for DataStage parallel jobs. You must collect this data after each job completes. What two options allow you to automatically save row counts and CPU time for each instance of an operator? (Choose two.)

  A. $APT_CPU_ROWCOUNT

  B. $APT_PERFORMANCE_DATA

  C. Enable the job property "Record job performance data".

  D. Open up the job in Metadata Workbench and select the "Data Lineage" option.

  E. Click the Performance Analysis icon in the toolbar to open the Performance Analyzer utility.

  Correct Answer: BC

• Question 115:

  Which two environment variables add additional reporting information in the job log for DataStage jobs? (Choose two.)

  A. $APT_IO_MAP

  B. $OSH_EXPLAIN

  C. $APT_STARTUP_STATUS

  D. $APT_EXPORT_FLUSH_COUNT

  E. $APT_PM_STARTUP_CONCURRENCY

  Correct Answer: BC

• Question 116:

  A job validates account numbers with a reference file using a Join stage, which is hash partitioned by account number. Runtime monitoring reveals that some partitions process many more rows than others. Assuming adequate hardware resources, which action can be used to improve the performance of the job?

  A. Replace the Join with a Merge stage.

  B. Change the number of nodes in the configuration file.

  C. Add a Sort stage in front of the Join stage. Sort by account number.

  D. Use Round Robin partitioning on the stream and Entire partitioning on the reference.

  Correct Answer: B

• Question 117:

  The Score is divided into which two sections? (Choose two.)

  A. Stages

  B. File sets

  C. Schemas

  D. Data sets

  E. Operators

  Correct Answer: DE

• Question 118:

  What two features distinguish the Operations Console from the Director job log? (Choose two.)

  A. Jobs can be started and stopped in Director, but not in the Operations Console.

  B. The Operations Console can monitor jobs running on only one DataStage engine.

  C. Workload management is supported within Director, but not in the Operations Console.

  D. The Operations Console can monitor jobs running on more than one DataStage engine.

  E. The Operations Console can run on systems where the DataStage clients are not installed.

  Correct Answer: DE

• Question 119:

  You are responsible for deploying objects into your customers production environment. To ensure the stability of the production system the customer does not permit compilers on production machines. They have also protected the project and only development machines have the required compiler. What option will enable jobs with a parallel transformer to execute in the customers production machines?

  A. Add $APT_COMPILE_OPT=-portable

  B. Set $APT_COPY_TRANSFORM_OPERATOR

  C. Use protected projects in the production environment.

  D. Create a package with Information Server Manager and select the option to include executables.

  Correct Answer: D

• Question 120:

  You want to find out which table definitions have been loaded into a job, and specifically which stages of the job they has been loaded into? How will you determine this?

  A. Select the job, right-click, then click the Find where used (deep) command.

  B. Select the job, right-click, then click the Find dependencies (deep) command.

  C. Select the job, right-click, then click the Find where used command. Then right-click and select "Show the dependency path from the job".

  D. Select the job, right-click, then click the Find dependencies command. Then right-click and select "Show the dependency path from the job".

  Correct Answer: D