IBM C2090-303 Online Practice Questions and Exam Preparation

IBM C2090-303 Online Questions & Answers

• Question 101:

  Which step is required to change from a normal lookup to a sparse lookup in an ODBC Connector stage?

  A. Change the partitioning to hash.
  B. Sort the data on the reference link.
  C. Change the lookup option in the stage properties to "Sparse".
  D. Replace columns at the beginning of a SELECT statement with a wildcard asterisk (*).
  C. Change the lookup option in the stage properties to "Sparse".

• Question 102:

  In your parallel job design you have selected a parallel shared container to be included.

  Which area of your job design is required to be configured to use the parallel shared container?

  A. List the jobs that will be allowed to use the container.
  B. Configure your job properties General tab "Allow Container" option to be True.
  C. Configure the job name reference the parallel shared container originates from.
  D. Configure the number of input and/or output links to support the parallel shared container.
  D. Configure the number of input and/or output links to support the parallel shared container.

• Question 103:

  What is the correct method to process a file containing multiple record types using a Complex Flat File stage?

  A. Flatten the record types into a single record type.
  B. Manually break the file into multiple files by record type.
  C. Define record definitions on the Constraints tab of the Complex Flat File stage.
  D. Load a table definition for each record type on the Records tab of the Complex Flat File stage.
  D. Load a table definition for each record type on the Records tab of the Complex Flat File stage.

• Question 104:

  What two binding types are supported by Information Services Director (ISD) for a parallel job that is designed to be used as a service? (Choose two.)

  A. EJB
  B. SQL
  C. HDFS
  D. SOAP
  E. STREAMS
  A. EJB
  D. SOAP

• Question 105:

  Suppose a user ID has been created with DataStage and QualityStage component authorization.

  Which client application would be used to give that user ID DataStage Developer permission?

  A. DataStage Director client
  B. DataStage Designer client
  C. DataStage Administrator client
  D. Information Server Web Console Administrator client
  C. DataStage Administrator client

• Question 106:

  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.
  B. Set $APT_PM_SHOW_PIDS to true.

• Question 107:

  Which two parallel job stages allow you to use partial schemas? (Choose two.)

  A. Peek stage
  B. File Set stage
  C. Data Set stage
  D. Column Export stage
  E. External Target stage
  B. File Set stage
  E. External Target stage

• Question 108:

  You want to find out which table definitions have been loaded into a job, and specifically which stages of the job they has been loaded into?

  How will you determine this?

  A. Select the job, right-click, then click the Find where used (deep) command.
  B. Select the job, right-click, then click the Find dependencies (deep) command.
  C. Select the job, right-click, then click the Find where used command. Then right-click and select "Show the dependency path from the job".
  D. Select the job, right-click, then click the Find dependencies command. Then right-click and select "Show the dependency path from the job".
  D. Select the job, right-click, then click the Find dependencies command. Then right-click and select "Show the dependency path from the job".

• Question 109:

  You have made a copy of your job and made major changes to a job in your project. You now want to identify all the changes that have been made. What task will allow you to identify these changes?

  A. Export the original job to a backup directory.
  B. Export the modified job to the backup directory.
  C. Select the job, then right click Compare against.
  D. Select the job, then right click Cross Project Compare.
  C. Select the job, then right click Compare against.

• Question 110:

  The derivation for a stage variable is: Upcase(input_column1) : ' ' :

  Upcase(input_column2).Suppose that input_column1 contains a NULL value. Assume the legacy NULL processing option is turned off.

  Which behavior is expected?

  A. The job aborts.
  B. NULL is written to the target stage variable.
  C. The input row is either dropped or rejected depending on whether the Transformer has a reject link.
  D. The target stage variable is populated with spaces or zeros depending on the stage variable data type.
  B. NULL is written to the target stage variable.