IBM C2090-421 Online Practice Questions and Exam Preparation

IBM C2090-421 Online Questions & Answers

• Question 171:

  Which Oracle Enterprise stage read property can be set using -dboptions to tune job performance?

  A. memsize
  B. arraysize
  C. transactsize
  D. partitionsize
  B. arraysize

• Question 172:

  Click the exhibit button.

  

  You submit a job from DataStage Director and then log onto your DataStage Linux server to issue the command "ps -ef | grep ds" and receive the following screen: Which process is a player?

  A. 7117
  B. 7215
  C. 7216
  D. 7217
  D. 7217

• Question 173:

  Where are project level message handlers defined?

  A. DSENV
  B. Director Client
  C. Designer Client
  D. Administrator Client
  D. Administrator Client

• Question 174:

  Which two properties can be set to read a fixed width sequential file in parallel? (Choose two.)

  A. Set Read Method to "File Pattern".
  B. Set the Execution mode to "Parallel".
  C. Set the "Read from Multiple Nodes" optional property to a value greater than 1.
  D. Set the "Number of Readers Per Node" optional property to a value greater than 1.
  C. Set the "Read from Multiple Nodes" optional property to a value greater than 1.
  D. Set the "Number of Readers Per Node" optional property to a value greater than 1.

• Question 175:

  You are running a DataStage job using a 2-node configuration file. How can a fixed-width single sequential file be read in parallel? (Choose two.)

  A. Use an external Source stage.
  B. Specify a node constraint for the SequentialFile stage.
  C. Set the Execution Mode to the SequentialFile stage to "Parallel".
  D. Set the "Read From Multiple Nodes" optional property to a value greater than 1.
  E. Set the "Number of Readers per Node" optional property to a value greater than 1.
  D. Set the "Read From Multiple Nodes" optional property to a value greater than 1.
  E. Set the "Number of Readers per Node" optional property to a value greater than 1.

• Question 176:

  You write a job control routine to control a sequence of jobs running as a single unit of work. What are three valid job status types you can trap for? (Choose three.)

  A. DSJS.START
  B. DSJS.RUNOK
  C. DSJS.STOPPED
  D. DSJS.RUNERROR
  E. DSJS.RUNFAILED
  B. DSJS.RUNOK
  C. DSJS.STOPPED
  E. DSJS.RUNFAILED

• Question 177:

  A client needs to process a flat file where a set of values in the import data columns should be treated as Null. What is the best way to handle multiple Null values using a Sequential File stage?

  A. On the Input Link format tab,specify the null values in double quotes separated by a comma in the Null field value property.
  B. On the Output Link format tab,specify the null values in double quotes separated by a comma in the Null field value property.
  C. On the Input Link format tab,specify a separator character in the dependent Null field value separator property and then use this separator to delimit the null values in the Null field value property. Click here to input option.
  D. On the Output Link format tab,specify a separator character in the dependent Null field value separator property and then use this separator to delimit the null values in the Null field value property.
  D. On the Output Link format tab,specify a separator character in the dependent Null field value separator property and then use this separator to delimit the null values in the Null field value property.

• Question 178:

  You are working on a project that contains a large number of jobs contained in many folders. You would like to review the jobs created by the former developer of the project. How can you find these jobs?

  A. Filter jobs in Director Client's Repository window.
  B. Sort the jobs by date in the Repository window.
  C. Use the Advanced Find feature contained in the Designer interface.
  D. While selecting the top folder in the project,choose Find Dependencies.
  C. Use the Advanced Find feature contained in the Designer interface.

• Question 179:

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

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

• Question 180:

  Which two statements are true regarding access to a MQ queue? (Choose two.)

  A. MQ stage connects to a queue manager in Client mode only.
  B. MQ stage and MQ connector stages support destructive reads.
  C. MQ plugin stage can be used to read and write messages from a remote MQ message queue.
  D. MQ connector stage is capable of connecting to Queue manager in both Server and Client mode.
  B. MQ stage and MQ connector stages support destructive reads.
  D. MQ connector stage is capable of connecting to Queue manager in both Server and Client mode.