IBM C2090-424 Online Practice Questions and Exam Preparation

IBM C2090-424 Online Questions & Answers

• Question 1:

  Which of the following is the default data type for the Aggregator stage during calculation?

  A. Integer
  B. Double
  C. VarChar
  D. Decimal
  B. Double

  ---

  Reference: https://datastage4u.wordpress.com/2011/04/27/the-aggregator-stage-datastage/

• Question 2:

  Which one of the following stages requires a schema file when using Runtime Column Propagation?

  A. Modify Stage
  B. Data Set Stage
  C. Transformer Stage
  D. Sequential File Stage
  D. Sequential File Stage

  ---

  Reference: https://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.ds.parjob.dev.doc/topic s/c_deeref_using_rcp_with_sequential_stages.html

• Question 3:

  When building an UPDATE statement in SQL Query builder, which of the following is TRUE?

  A. Predicates cannot refine what rows are updated
  B. Table(s) referenced must have table definitions imported previously
  C. Column values can be job parameters or input columns but not expressions
  D. Columns to update must be selected individually from the column selection grid
  D. Columns to update must be selected individually from the column selection grid

• Question 4:

  What COBOL data type is defined by Decimal data within the Complex Flat File stage?

  A. COMP
  B. COMP-1
  C. COMP-2
  D. COMP-3
  C. COMP-2

• Question 5:

  In order to collect operational metadata, you must do which of the following?

  A. Enable "Generate operational metadata" in the Execution tab of the job properties using the Designer client
  B. Enable "Generate operational metadata" in the General tab of the project properties using the Director client
  C. Enable "Record job performance data" in the General tab of the project properties using the Administrator client
  D. Enable "Generate operational metadata" in the General tab of the Job Run Options dialog box in the Director client
  C. Enable "Record job performance data" in the General tab of the project properties using the Administrator client

  ---

  Reference: https://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.ds.admin.doc/topics/t_d aclref_Capturing_Process_Meta_Data.html

• Question 6:

  A job consist of Sequential File Stage -> Copy Stage using auto partitioning -> Sequential File stage. We need the target Sequential File stage rows to be in the same order as the source file. Which collection algorithm should be chosen in the target Sequential File stage?

  A. Auto
  B. Same
  C. Round robin
  D. Sorted merge
  D. Sorted merge

• Question 7:

  Which of the following is the correct schema format for a Time column?

  A. record (tField:time[hour:minute:second];)
  B. record (tField:nullable time[];)
  C. record (tField:time[seconds];)
  D. record (tField:time[microseconds];)
  C. record (tField:time[seconds];)

  ---

  Reference: https://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.ds.parjob.dev.doc/topic s/r_deeref_Time_Columns.html

• Question 8:

  Archive files can contain assets from multiple exports of multiple tools. When importing into a project from an archive file with the istool command, which order of asset types below would yield the best performance?

  A. Users and groups, Common metadata, InfoSphere DataStage and QualityStage assets, Reports, Custom attributes for InfoSphere Information Covernance Catalog
  B. Common metadata, Users and groups, Custom attributes for InfoSphere Information Governance Catalog, InfoSphere DataStage and QualityStage assets, Reports
  C. Common metadata, Users and groups, Custom attributes for InfoSphere Information Governance Catalog, InfoSphere Data Stage and QualityStage assets
  D. Users and groups, Common metadata, InfoSphere DataStage and QualityStage assets, Custom attributes for InfoSphere Information Governance Catalog, Reports
  A. Users and groups, Common metadata, InfoSphere DataStage and QualityStage assets, Reports, Custom attributes for InfoSphere Information Covernance Catalog

• Question 9:

  Which of the following is NOT a valid use of stage variables?

  A. Storing values to be used in both derivations and constraints
  B. Storing values that can be referenced by name in downstream stages
  C. Storing values from one row to compare with values in the next row read
  D. Storing the result on an expression to be used in multiple output columns
  D. Storing the result on an expression to be used in multiple output columns

• Question 10:

  Which of the following actions are available when editing a message handler?

  A. Abort Job
  B. Demote to warning
  C. Promote to warning
  D. Promote to informational
  C. Promote to warning

  ---

  Reference: http://www-01.ibm.com/support/knowledgecenter/SSZJPZ_8.5.0/com.ibm.swg.im.iis.ds.design.help.doc/topics /editmessagehandlerswindow.html