IBM C2090-303 Online Practice Questions and Exam Preparation

IBM C2090-303 Online Questions & Answers

• Question 21:

  Which statement is true about improving job performance when using Balanced Optimization?

  A. Convert a job to use bulk staging tables for Big Data File stages.
  B. Balance optimization attempts to balance the work between the source server, target sever, and the job.
  C. If the job contains an Aggregator stage, data reduction stages will be pushed into a target data server by default.
  D. To ensure that a particular stage can only be pushed into a source or target connector, you can set the Stage Affinity property to source or target.
  D. To ensure that a particular stage can only be pushed into a source or target connector, you can set the Stage Affinity property to source or target.

• Question 22:

  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
  D. 8

• Question 23:

  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.
  D. Using the advanced find dialog, specify in the last modified panel, the date range of the jobs, and appropriate user name.

• Question 24:

  What is the result of running the following command: dsjob -report DSProject ProcData

  A. Generates a report about the ProcData job, including information about its stages and links.
  B. Returns a report of the last run of the ProcData job in a DataStage project named DSProject.
  C. Runs the DataStage job named ProcData and returns performance information, including the number of rows processed.
  D. Runs the DataStage job named ProcData and returns job status information, including whether the job aborted or ran without warnings.
  B. Returns a report of the last run of the ProcData job in a DataStage project named DSProject.

• Question 25:

  Which stage classifies data rows from a single input into groups and computes totals?

  A. Modify stage
  B. Compare stage
  C. Aggregator stage
  D. Transformer stage
  C. Aggregator stage

• Question 26:

  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.
  B. Use the "Shared Table Creation Wizard" to place the table in the shared repository.

• Question 27:

  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.
  B. $APT_PERFORMANCE_DATA
  C. Enable the job property "Record job performance data".

• Question 28:

  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.
  B. Change the number of nodes in the configuration file.

• Question 29:

  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.
  C. After installation DataStage projects can be created in DataStage Administrator.

• Question 30:

  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
  B. Key partitioned
  E. Sorted by Join key