IBM C2090-421 Online Practice Questions and Exam Preparation

IBM C2090-421 Online Questions & Answers

• Question 141:

  Which of the following is not an ODBC connector property?

  A. Username
  B. Password
  C. Data source
  D. Remote server
  D. Remote server

• Question 142:

  What two repositories does the Source Code Control Integration for DataStage and QualityStage serve? (Choose two.)

  A. Source Code Repository
  B. Universe Project Repository
  C. Information Analyzer Repository
  D. Information Server meta-data Repository
  A. Source Code Repository
  D. Information Server meta-data Repository

• Question 143:

  A customer requests you to configure a Sequential File stage in a clustered environment. The stage must read a varying number of files each run in a single pass and append the name of the file the row was read from when an error occurs. What three steps are required to achieve this? (Select three)

  A. Specify multiple "File" properties.
  B. Specify File Name Column property.
  C. Set environment variable $APT_SEQ_FILE_INCL_FILENAMES.
  D. Set environment variable $APT_IMPORT_PATTERN_USES_FILESET.
  E. Specify a file pattern option along with a file name mask that captures entire file list.
  B. Specify File Name Column property.
  D. Set environment variable $APT_IMPORT_PATTERN_USES_FILESET.
  E. Specify a file pattern option along with a file name mask that captures entire file list.

• Question 144:

  Which two property areas must be configured when using the ODBC connector stage as a target in your job design? (Choose two.)

  A. Define columns for the output link.
  B. Specify the remote server property.
  C. Specify properties for the input link.
  D. Define the connection properties to an ODBC data source.
  C. Specify properties for the input link.
  D. Define the connection properties to an ODBC data source.

• Question 145:

  A scenario requires selecting only the most recent transactions for each of 2 million unique customers, from a 20 million row DB2 source table containing order history. Which parallel job design would satisfy this functional requirement?

  A. Using the Dynamic Relational stage,use custom SQL to select all DISTINCT customer numbers from the order history table.
  B. Select all rows using the ODBC Connector stage,use a Sort Aggregator on customer number key to select the maximum order date.
  C. Using the DB2 Enterprise stage,select all rows. Perform a unique Sort using customer number and order date sort keys in ascending order.
  D. Using the DB2 API stage,select all rows. Use a Sort stage with customer number and order date sort keys in ascending order,then Remove Duplicates with Last Duplicate to retain.
  D. Using the DB2 API stage,select all rows. Use a Sort stage with customer number and order date sort keys in ascending order,then Remove Duplicates with Last Duplicate to retain.

• Question 146:

  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 "Reset if required,then run.".
  D. 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.".
  C. In the Job1 Activity stage set the Execution action to "Reset if required,then run.".

• Question 147:

  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 two options will allow jobs with a parallel transformer to execute in the customers production machines? (Choose two.)

  A. Add $APT_COMPILE_OPT=-portable
  B. Set $APT_COPY_TRANSFORM_OPERATOR
  C. Export the jobs with Information Server Manager with the executables.
  D. Create a package with Information Server Manager and select the option to include executables.
  C. Export the jobs with Information Server Manager with the executables.
  D. Create a package with Information Server Manager and select the option to include executables.

• Question 148:

  You are responsible for managing job changes for you project team. You must update the source code repository through Eclipse Team source code integration whenever a developer notifies you of an asset change. What two tasks allow you to update the source code repository with the changed asset? (Select two)

  A. Right-click the asset and click the Build command
  B. Right-click the asset and click the Deploy command
  C. Right-click the asset and click the Send to Source Control Work Space.
  D. Right-click the asset and click the Team command to commit the artifact to the source control system.
  A. Right-click the asset and click the Build command
  D. Right-click the asset and click the Team command to commit the artifact to the source control system.

• Question 149:

  What are two fundamental functions of the Information Server Source Code Integration based on the Eclipse Team framework? (Choose two.)

  A. Commit Changes
  B. Rollback Changes
  C. Send to Source Code Control Workspace
  D. Replace from Source Code Control Workspace
  C. Send to Source Code Control Workspace
  D. Replace from Source Code Control Workspace

• Question 150:

  A job contains a Sort stage that sorts a large volume of data across a cluster of servers. Due to new requirements, the customer has requested that this sorting be done on a subset of servers identified in the configuration file to minimize impact on database nodes. The $APT_CONFIG_FILE shows no sort disk pool for any node. Which two steps will accomplish this? (Choose two.)

  A. Assign a separate config file just for the Sort stage.
  B. Have an appropriate node constraint within the Sort stage.
  C. Use the environment variable $APT_SCRATCH_SPACE_SORT_USAGE.
  D. Define a non-default node pool with a subset of nodes in the parallel configuration file.
  E. Create a sort scratch disk pool with a subset of nodes in the parallel configuration file.
  B. Have an appropriate node constraint within the Sort stage.
  D. Define a non-default node pool with a subset of nodes in the parallel configuration file.