IBM C2090-424 Online Practice Questions and Exam Preparation

IBM C2090-424 Online Questions & Answers

• Question 21:

  Which of the following will run the DataStage job in the Unix environment for the domain is1:9445, server is1 for the user srv_etl?

  A. dsjob –domain is1:9445 –server is1 –user srv_etl –run dstage1 jTest101
  B. dsjob –domain is1:9445 –server is1 –userid srv_etl –password {iisenc}infosphere –run dstage1 jTest101
  C. dsjob –domain is1:9445 –server is1 –username srv_etl –password iisenc_infosphere –run dstage1 jTest101
  D. dsjob –domain is1:9445 –server is1 –user srv_etl –password {iisenc} QHw0Q6i1zBuHhM3HcHPQrw= = -run dstage1 jTest101
  B. dsjob –domain is1:9445 –server is1 –userid srv_etl –password {iisenc}infosphere –run dstage1 jTest101

  ---

  Reference: https://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.mmi.doc/topics/t_import ing_metadata_into_staging_area.html

• Question 22:

  Which of the following statements about real time job design is TRUE?

  A. DSJobInvocationId is not required for the target sequential file.
  B. A non-Multiple Instance DataStage job can be activated for ISD service.
  C. A DataStage job must have an ISD Input stage, but an ISD Output stage is not required.
  D. The Information Services Director server starts job instances on one or more DataStage servers for load balancing and scalability.
  D. The Information Services Director server starts job instances on one or more DataStage servers for load balancing and scalability.

  ---

  Reference: https://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.5.0/com.ibm.swg.im.iis.infoservdir.user.doc/topi cs/c_isd_user_ds_qs_job_topologies.html (See 2nd paragraph).

• Question 23:

  Which of the following is TRUE when using a data set created with a 4 node config file?

  A. Data sets are operating system files
  B. Data is stored in a non-persistent form
  C. The data set control file holds all your data
  D. A Data Set stage can have 1 input link and multiple output links
  B. Data is stored in a non-persistent form

• Question 24:

  When you read or write to a sequential file, and wish to have a value be identified with DataStage as NULL, which of the following is the correct option?

  A. Set format's fill char option using the value
  B. Set string type default option using the value
  C. Set format's null field value option using the value
  D. Set $APT_IMPEXP_REJECT_NULLS using the value
  B. Set string type default option using the value

  ---

  Reference: https://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.ds.serverjob.dev.doc/to pics/r_dsvjbref_Defining_Sequential_File_Output_Data.html

• Question 25:

  To run multiple copies of the same job within Director, which of the following must be supplied?

  A. Job name
  B. Invocation ID
  C. Parameter values
  D. Username and password
  C. Parameter values

• Question 26:

  Parallel job column definitions have an SQL type associated with them. Which of the following is TRUE?

  A. Use the SQL type when specifying a schema via a file
  B. The SQL type is what the parallel job data set understands
  C. Use the Parallel tab of the Edit Column Meta Data dialog box to view the SQL type
  D. The SQL type is mapped to an underlying data type that the parallel job data set understands
  C. Use the Parallel tab of the Edit Column Meta Data dialog box to view the SQL type

  ---

  Reference: https://www-01.ibm.com/support/knowledgecenter/SSZJPZ_9.1.0/com.ibm.swg.im.iis.ds.parjob.dev.doc/topics/ c_deeref_Data_Types.html

• Question 27:

  Which of the following is an FTP Collection method?

  A. Hash
  B. Same
  C. Random
  D. Sort Merge
  D. Sort Merge

• Question 28:

  Which of the following will determine the running row number within a group?

  A. Insert an Aggregator stage, hashing on the key column, prior to the Transformer stage
  B. Use a Surrogate Key Generator stage to generate the running row number prior to the Transformer stage
  C. Use a Remove Duplicates stage prior to the Transformer stage based on the key column, with the Duplicate set to retain = last option
  D. Use a Sort stage prior to the Transformer stage based on the key break column. Then, use the LastRowinGroup() function to determine the last row in a group
  D. Use a Sort stage prior to the Transformer stage based on the key break column. Then, use the LastRowinGroup() function to determine the last row in a group

• Question 29:

  You want to retain the record with the largest value in the TotalAmount column for each CustID and ProductType using a Remove Duplicates stage. How can this be accomplished?

  A. Hash partition on TotalAmount. Sort on CustID, ProductType and TotalAmount
  B. Hash partition on ProductType. Sort on CustID, ProductType and TotalAmount
  C. Hash partition on CustID and ProductType. Sort on CustID, ProductType and TotalAmount
  D. Hash partition on CustID, ProductType and TotalAmount. Sort on CustID, ProductType and TotalAmount
  C. Hash partition on CustID and ProductType. Sort on CustID, ProductType and TotalAmount

• Question 30:

  Given this score:

  

  It runs 3 processes on 2 nodes. How does the job run?

  A. On two physical nodes and two logical nodes
  B. On two physical nodes and single logical node
  C. On a single physical node and two logical nodes
  D. On a single physical node and single logical node
  D. On a single physical node and single logical node