IBM C2090-421 Online Practice Questions and Exam Preparation

IBM C2090-421 Online Questions & Answers

• Question 181:

  You are responsible for the projects Source Code Repository. When a developer notifies you that changes are ready to deploy you must first check them in. You will use the Information Server Source Code integration features to check in the changed assets. How will you identify the DataStage assets the developer modified in order to send them to the workspace?

  A. From the Information Server Manager Select the project then right-click on Synchronize with source code control system.
  B. Use Designer client Advanced Find,specify a modification date and the developer's username in the Modified by fields.
  C. From Information Server Manager use Search with advanced options,specify a date modified and the developer's user name in the Modified by fields.
  D. From the workspace perspective select the project Right-click then Refresh from repository,specify a modification date and the developer's username in the Modified by fields.
  C. From Information Server Manager use Search with advanced options,specify a date modified and the developer's user name in the Modified by fields.

• Question 182:

  What three statements are true with regards to restartable mode for an FTP Enterprise stage? (Select three)

  A. Specify the-restartable_transfer option.
  B. Optionally specify a unique job_id for the transfer.
  C. File URIs that were transferred completely are not transferred again.
  D. Specify a checkpoint directory for the transfer using the -checkpointdir directory.
  E. Checkpoint files are written to /^"checkpoint directory">/pftpJobid_ .
  B. Optionally specify a unique job_id for the transfer.
  D. Specify a checkpoint directory for the transfer using the -checkpointdir directory.

• Question 183:

  You are processing groups of rows in a Transformer. The first row in each group contains "1" in the Flag column and "0" in the remaining rows of the group. At the end of each group you want to sum and output the QTY column values. Which three techniques will enable you to retrieve the sum of the last group? (Choose three.)

  A. Output the sum that you generated each time you process a row for which the LastRow() function returns True.
  B. Output the sum that you generated up to the previous row each time you process a row with a "1" in the Flag column.
  C. Within each group sort the Flag column in ascending order. Output the sum each time you process the row with a "1" in the Flag column.
  D. Output a running total for each group for each row. Follow the Transformer stage by an Aggregator stage. Take the MAX of the QTY column for each group.
  E. Output the sum that you generated up to the previous row each time you process a row with a "1" in the Flag column. Use the LastRow() function to determine when the last group is done.
  C. Within each group sort the Flag column in ascending order. Output the sum each time you process the row with a "1" in the Flag column.
  D. Output a running total for each group for each row. Follow the Transformer stage by an Aggregator stage. Take the MAX of the QTY column for each group.
  E. Output the sum that you generated up to the previous row each time you process a row with a "1" in the Flag column. Use the LastRow() function to determine when the last group is done.

• Question 184:

  What three element Names are required to create Shared metadata? (Choose three.)

  A. Schema
  B. Database
  C. Project Name
  D. Host System
  E. Database Instance
  A. Schema
  B. Database
  D. Host System

• Question 185:

  You would like to invoke a job sequence from a web service. How can this be done?

  A. Invoke the job sequence using the dsjob command.
  B. Select the job sequence when creating the web service operation,
  C. Check the use job sequence checkbox when creating the web service.
  D. Create a DataStage routine that invokes the job sequence and invoke the routine from a DataStage job. Then use this job when creating the web service operation.
  D. Create a DataStage routine that invokes the job sequence and invoke the routine from a DataStage job. Then use this job when creating the web service operation.

• Question 186:

  When creating a Wrapper stage, which three tasks need to be done? (Select three)

  A. Code and compile the C/C++ Wrapper source code.
  B. Specify the command to be executed by the Wrapper.
  C. Specify how Wrapper property values are to be converted.
  D. Specify whether input rows are to be processed automatically or manually.
  E. Create Table Definitions that define the Wrapper's input and output columns.
  B. Specify the command to be executed by the Wrapper.
  C. Specify how Wrapper property values are to be converted.
  E. Create Table Definitions that define the Wrapper's input and output columns.

• Question 187:

  Click on the Exhibit button.

  

  Provided you have enough system resources, what is the maximum number of jobs that could be running concurrently in this image?

  A. 2
  B. 3 C. 4
  D. 5
  B. 3 C. 4

• Question 188:

  What is the lowest CPU cost partitioning method?

  A. Hash
  B. Entire
  C. Random
  D. Round Robin
  D. Round Robin

• Question 189:

  Which two partitioning methods require keys? (Choose two.)

  A. Hash
  B. Entire
  C. Modulus
  D. Round Robin
  A. Hash
  C. Modulus

• Question 190:

  You would like to run a particular processing job within a job sequence for each weekday of the week. How could you do this? (Select two)

  A. Set the frequency property in the job scheduler to weekdays only.
  B. Call a routine in the job sequencer that starts the processing job for each day you would like to process.
  C. Have a parameter set that contains the days of the week you would like to process and routine to parse the days of the week contained in the "day" parameter.
  D. Start Loop and End Loop activity stages on the job sequencer canvas where you loop through the days and pass a value for each day into the job via parameter.
  A. Set the frequency property in the job scheduler to weekdays only.
  D. Start Loop and End Loop activity stages on the job sequencer canvas where you loop through the days and pass a value for each day into the job via parameter.