IBM C2090-424 Online Practice Questions and Exam Preparation

IBM C2090-424 Online Questions & Answers

• Question 41:

  Which is NOT a valid native operator for OSH?

  A. Sort
  B. Copy
  C. Import
  D. Generator
  A. Sort

• Question 42:

  By default, how much internal memory does the Sort use per partition?

  A. 10MB
  B. 20MB
  C. 25MB
  D. 30MB
  B. 20MB

  ---

  Reference: https://datastage4u.wordpress.com/2011/04/26/sorting-in-datastage/

• Question 43:

  The APT_SubProcessOperator is used for what purpose?

  A. It allows you to incorporate a third-party executable into the framework
  B. It provides the capability to break predefined operators into sub processes
  C. It provides the capability to define custom operators at the sub process level
  D. It allows you to incorporate composite operators, which contain more than one operator
  A. It allows you to incorporate a third-party executable into the framework

  ---

  Reference: https://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.ds.pxop.dev.doc/topics/ creatingopers.html

• Question 44:

  Your job consists of a DB2 Connector stage followed by a Sort stage followed by a Transformer stage followed by another DB2 Connector stage.

  The following two Balanced Optimizer options have been selected:

  Push processing to data sources

  Push processing to data targets

  The following two Balanced Optimizer options have NOT been selected:

  Push data reduction processing to data targets

  Push all processing into the (target) data server

  Assuming the job design allows for maximum optimization, what does the optimized job design look like?

  A. Row Generator stage followed by a DB2 Connector stage
  B. DB2 Connector stage followed by a DB2 Connector stage
  C. DB2 stage followed by a Transformer stage followed by a DB2 Connector stage
  D. DB2 Connector stage followed by a Sort stage followed by a Transformer stage followed by another DB2 Connector stage
  A. Row Generator stage followed by a DB2 Connector stage

• Question 45:

  Which statement about restartable sequence jobs is TRUE?

  A. If a restartable sequence aborts, it can be restarted from Director.
  B. Choosing "Reset job" from Director will start the job where it left off.
  C. Checkpoints are always added to every eligible Job Activity stage in the sequence.
  D. There is no way to force a Job Activity stage to return if the sequence got beyond it.
  A. If a restartable sequence aborts, it can be restarted from Director.

  ---

  Reference: http://www-01.ibm.com/support/docview.wss?uid=swg1JR46534

• Question 46:

  A job is designed with 3 Join stages in sequence.

  Join_1 keys are "Account", "Customer" and "PO_Date"

  Join_2 keys are "Account", "Customer" and "Txn"

  Join_3 keys are "Account", "Product_CD" and "Txn"

  Which of the following will lead to the best run time performance?

  A. Left links are Hash partitioned on "Account" for all joins Right links are Hash partitioned on "Account" for all joins
  B. Both left and right links are Hash partitioned as follows: Join_1 by "Account", "Customer" and "PO_Date" Join_2 by "Account", "Customer" and "Txn" Join_3 by "Account", "Product_CD" and "Txn"
  C. Both left and right links are Hash partitioned as follows: Join_1 by "Account" and "Customer" Join_2 by "Account" and "Customer" Join_3 by "Account"
  D. Left links are Hash partitioned on "Account" for the first two joins and on "Product_CD" for the third. Right links are Hash partitioned on "Account" for all joins
  A. Left links are Hash partitioned on "Account" for all joins Right links are Hash partitioned on "Account" for all joins

• Question 47:

  For very large records, you may need to set the following environment variable with an appropriate value in order to allow the job to run successfully:

  A. $APT_MONITOR_SIZE
  B. $APT_RECORD_COUNTS
  C. $APT_DISABLE_COMBINATION
  D. $APT_DEFAULT_TRANSPORT_BLOCK_SIZE
  D. $APT_DEFAULT_TRANSPORT_BLOCK_SIZE

• Question 48:

  The encrypt.sh or the encrypt.bat script can be used to do which of the following?

  A. Secure sensitive personal data
  B. To set up credentials files used by the dsjob command
  C. Assisting in decoding encrypted rows of input during debugging
  D. Assisting in preparing encrypted rows of output during job execution
  D. Assisting in preparing encrypted rows of output during job execution

  ---

  Reference: https://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.conn.filecon.usage.doc/ topics/filecon_t_enable_ssl_connect.html

• Question 49:

  Which of the following are valid stage options for a parallel DataStage job which uses a configuration file with multiple nodes and a File Connector as a source running in parallel mode? (Choose two.)

  A. Provide a specific file name in the file name property.
  B. In the file name property, provide a file name with a wildcard that matches the existing file names.
  C. Provide a specific file name in the file name property and select the option "Number of Readers Per Node" to be greater than 1.
  D. Set the read method with specific file(s), set the Read From Multiple Nodes = yes, and provide the specific file in the file property.
  E. Set the read method with a file pattern and provide a file name with a wildcard that matches the existing file names in the file pattern property.
  C. Provide a specific file name in the file name property and select the option "Number of Readers Per Node" to be greater than 1.
  D. Set the read method with specific file(s), set the Read From Multiple Nodes = yes, and provide the specific file in the file property.

• Question 50:

  Record Count property is set to zero in Connector stage. How many rows are written out?

  A. All Rows
  B. One Row
  C. Zero Rows
  D. 2000 Rows
  A. All Rows

  ---

  Reference: http://www-01.ibm.com/support/knowledgecenter/SSZJPZ_8.7.0/com.ibm.swg.im.iis.conn.db2db.help.doc/topi cs/props_input_db2.html?lang=en