IBM IBM Certified Solution Developer A2090-303 Questions & Answers

• Question 1:

  Identify two restructure stages that allow you to create or organize vectors in the output link results? (Choose two.)

  A. Split Vector

  B. Column Import

  C. Split Subrecord

  D. Merge records

  E. Make Subrecord

  Correct Answer: CE

• Question 2:

  When using a Sequential File stage as a source what are the two reject mode property options? (Choose two.)

  A. Set

  B. Fail

  C. Save

  D. Continue

  E. Convert

  Correct Answer: BD

• Question 3:

  Which of following two pieces of information are required to be specified for the input link on a Netezza Connector stage? (Choose two.)

  A. Partitioning

  B. Server name

  C. Buffering settings

  D. Table definitions

  E. Error log directory

  Correct Answer: AC

• Question 4:

  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. Project name

  C. Host system

  D. Database instance

  E. DataStage server system name

  Correct Answer: AC

• Question 5:

  A job design consists of an input Row Generator stage, a Filter stage, followed by a Transformer stage and an output Sequential File stage. The job is run on an SMP machine with a configuration file defined with three nodes. The $APT_DISABLE_COMBINATION variable is set to True.

  How many player processes will this job generate?

  A. 2

  B. 4

  C. 6

  D. 8

  Correct Answer: D

• Question 6:

  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 7:

  Click the Exhibit button.

  

  The job in the exhibit runs to successful completion with no warnings. However, a validation test identifies that the CUSTOMER_MASTER table is empty. You suspect the cause to be related to the NEW_CUSTOMERS table or a defect in the job. Examining runtime metadata may help you track down the problem. Which two product features will help you isolate the cause of the problem? (Choose two.)

  A. Director job monitor tool.

  B. Designer Performance Analyzer tool.

  C. Designer "Show performance statistics" option.

  D. The view data button in the target Connector stage.

  E. InfoSphere Metadata Asset Manager (IMAM) operational metadata reports.

  Correct Answer: AC

• Question 8:

  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 step should you take to understand the job performance issues?

  A. Replace Join stages by Lookup stages.

  B. Run the job with $APT_TRACE_RUN set to true.

  C. Run the job with $APT_DUMP_SCORE set to true.

  D. Replace Transformer stages with custom operators.

  Correct Answer: C

• Question 9:

  Which job log message heading identifies the score in the job log?

  A. OSH script ...

  B. main_program: orchgeneral: loaded

  C. main_program: Broadcasting score.

  D. main_program: This step has 3 datasets: ...

  Correct Answer: D

• Question 10:

  What two computer system resources on the DataStage engine are monitored in the Operations Console? (Choose two.)

  A. Disk

  B. CPU

  C. Memory

  D. Scratch disk

  E. XMETA database

  Correct Answer: BC