IBM C2090-303 Online Practice Questions and Exam Preparation

IBM C2090-303 Online Questions & Answers

• Question 91:

  The data going into the target Sequential Files stage is range-partitioned and sorted.

  Which technique method would be the most efficient to create a globally sorted target sequential file?

  A. Select an in-stage sort in the final Sequential File stage.
  B. Select the Ordered collector method for the final Sequential File stage.
  C. Select the Sort Merge collector method for the final Sequential File stage.
  D. Insert a Funnel stage before the final Sequential File stage and select Sequence as Funnel Type.
  B. Select the Ordered collector method for the final Sequential File stage.

• Question 92:

  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.
  B. Set the environment variable $APT_SORT_INSERTION_CHECK_ONLY.
  E. Add a parallel sort stage before each Join input, specifying the "Don't Sort, Previously Grouped" sort key mode for each key.

• Question 93:

  Your customer is using Source Code Control Integration for Information server and have tagged artifacts for version 1. You must create a deployment package from the version 1. Before you create the package you will have to ensure the project is up to date with version 1.

  What two things must you do to update the meta-data repository with the artifacts tagged as version 1? (Choose two.)

  A. Right-click the asset and click the Deploy command.
  B. Right-click the asset and click the Team Import command.
  C. Right-click the asset and click Update From Source Control Workspace.
  D. Right-click the asset and click Replace From Source Control Workspace.
  E. Right-click the asset and click the Team command to update the Source Control Workspace with the asset.
  D. Right-click the asset and click Replace From Source Control Workspace.
  E. Right-click the asset and click the Team command to update the Source Control Workspace with the asset.

• Question 94:

  Which statement describes what happens when Runtime Column Propagation is disabled for a parallel job?

  A. An input column value flows into a target column only if it matches it by name.
  B. An input column value flows into a target column only if it is explicitly mapped to it.
  C. You must set APT_AUTO_MAP project environment to true to allow output link mapping to occur.
  D. An input column value flows into a target column based on its position in the input row. For example, first column in the input row goes into the first target column.
  B. An input column value flows into a target column only if it is explicitly mapped to it.

• Question 95:

  The Change Apply stage produces a change Data Set with a new column representing the code for the type of change.

  What are two change values identified by these code values? (Choose two.)

  A. Edit
  B. Final
  C. Copy
  D. Deleted
  E. Remove Duplicates
  C. Copy
  D. Deleted

• Question 96:

  Which statement is true about table definitions created in DataStage Designer?

  A. By default, table definitions created in DataStage Designer are visible to other Information Server products.
  B. Table definitions created in DataStage Designer are local to DataStage and cannot be shared with other Information Server products.
  C. When a table definition is created in one DataStage project, it is automatically available in other DataStage projects, but not outside of DataStage.
  D. Table definitions created in DataStage Designer are not by default available to other Information Server products, but they can be shared with other Information Server products.
  D. Table definitions created in DataStage Designer are not by default available to other Information Server products, but they can be shared with other Information Server products.

• Question 97:

  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
  A. Inner join
  D. Right outer join

• Question 98:

  The number of File Set data files created depends upon what two items? (Choose two.)

  A. Amount of memory.
  B. Schema definition of the file.
  C. Operating system limitations.
  D. Number of logical processing nodes.
  E. Number of disks in the export or default disk pool connected to each processing node in the default node pool.
  D. Number of logical processing nodes.
  E. Number of disks in the export or default disk pool connected to each processing node in the default node pool.

• Question 99:

  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.
  B. Severity levels specify the threshold for saving events in the metadata repository.

• Question 100:

  Your job sequence must be restartable. It runs Job1, Job2, and Job3 serially. It has been compiled with "Add checkpoints so sequence is restartable". Job1 must execute every run even after a failure. Which two properties must be selected to ensure that Job1 is run each time, even after a failure? (Choose two.)

  A. Set the Job1 Activity stage to "Do not checkpoint run".
  B. Set trigger on the Job1 Activity stage to "Unconditional".
  C. In the Job1 Activity stage set the Execution action to "Run".
  D. In the Job1 Activity stage set the Execution action to "Reset if required, then run".
  E. Use the Nested Condition Activity with a trigger leading to Job1; set the trigger expression type to "Unconditional".
  A. Set the Job1 Activity stage to "Do not checkpoint run".
  D. In the Job1 Activity stage set the Execution action to "Reset if required, then run".