IBM C2090-303 Online Practice Questions and Exam Preparation

IBM C2090-303 Online Questions & Answers

• Question 1:

  In a file defining a partial schema, which two properties define the record? (Choose two.)

  A. intact
  B. delim
  C. position
  D. length_of_record
  E. record_delim_string
  A. intact
  E. record_delim_string

• Question 2:

  On the DataStage development server, you have been making enhancements to a copy of a DataStage job running on the production server. You have been asked to document the changes you have made to the job. What tool in DataStage Designer would you use?

  A. Compare Against
  B. diffapicmdline.exe
  C. DSMakeJobReport
  D. Cross Project Compare
  D. Cross Project Compare

• Question 3:

  Identify two restructure stages that allow you to create or organize vectors in the output link results? (Choose two.)

  A. Split Vector
  B. Column Import
  C. Merge records
  D. Split Subrecord
  E. Make Subrecord
  D. Split Subrecord
  E. Make Subrecord

• Question 4:

  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

• Question 5:

  Which job log message heading identifies the score in the job log?

  A. OSH script ...
  B. main_program: orchgeneral: loaded
  C. main_program: Broadcasting score.
  D. main_program: This step has 3 datasets: ...
  D. main_program: This step has 3 datasets: ...

• Question 6:

  What two features distinguish the Operations Console from the Director job log? (Choose two.)

  A. Jobs can be started and stopped in Director, but not in the Operations Console.
  B. The Operations Console can monitor jobs running on only one DataStage engine.
  C. Workload management is supported within Director, but not in the Operations Console.
  D. The Operations Console can monitor jobs running on more than one DataStage engine.
  E. The Operations Console can run on systems where the DataStage clients are not installed.
  D. The Operations Console can monitor jobs running on more than one DataStage engine.
  E. The Operations Console can run on systems where the DataStage clients are not installed.

• Question 7:

  Which two statements about the Additional Connections Options property in the Teradata Connector stage to specify details about the number of connections to Teradata are true? (Choose two.)

  A. The default for requestedsessions is the minimum number of available sessions.
  B. The default for requestedsessions is the maximum number of available sessions.
  C. Requestedsessions is a number between 1 and the number of vprocs in the operating system.
  D. Sessionsperplayer determines the number of connections each player in the job has to Teradata.
  E. Total requested sessions equals sessions per player multiplied by number of nodes multiplied by players per node. The default value is 4.
  B. The default for requestedsessions is the maximum number of available sessions.
  D. Sessionsperplayer determines the number of connections each player in the job has to Teradata.

• Question 8:

  The parallel framework was extended for real-time applications. Identify two of these aspects. (Choose two.)

  A. XML stage.
  B. End-of-wave.
  C. Real-time stage types that re-run jobs.
  D. Real-time stage types that keep jobs always up and running.
  E. Support for transactions within source database connector stages.
  B. End-of-wave.
  D. Real-time stage types that keep jobs always up and running.

• Question 9:

  When optimizing a job, Balanced Optimization will NOT search the job for what pattern?

  A. Links
  B. Stages
  C. Sequencers
  D. Property Settings
  C. Sequencers

• Question 10:

  Indicate two possible job design topologies that Information Services Director (ISD) parallel jobs can conform to. (Choose two.)

  A. A job with a single ISD Transformation stage.
  B. A job with one ISD Input stage and no ISD Output stage.
  C. A job with no ISD Input stage and with one ISD Output stage.
  D. A job with greater then one ISD input stage and one ISD Output stage.
  E. A job with one ISD Input stage and greater then one ISD Output stage.
  B. A job with one ISD Input stage and no ISD Output stage.
  C. A job with no ISD Input stage and with one ISD Output stage.