IBM C2090-424 Online Practice Questions and Exam Preparation

IBM C2090-424 Online Questions & Answers

• Question 51:

  In your project there is a top level Sequencer job which has multiple sub sequencers and jobs. You have to move this Sequencer job to a new project. How do you determine which objects have to be exported?

  A. Select top level sequencer job and click on "Export" option
  B. Select top level sequencer job and click on "Find dependencies" option
  C. Select top level sequencer job and click on "Find dependencies (deep)" option
  D. Select top level sequencer job and click on "Edit->Job Properties -> Dependencies"
  D. Select top level sequencer job and click on "Edit->Job Properties -> Dependencies"

• Question 52:

  In order to use Cognos TM1 Connector, which statement is TRUE?

  A. Installing the Cognos TM1 API component alone is sufficient.
  B. Import the IBM Cognos TM1 certificate and create a property file that stores truststore password
  C. Install the Cognos TM1 API component and create a property file that stores truststore password
  D. Install the Cognos TM1 API component and import the IBM Cognos TM1 certificate and create a property file that stores truststore password
  D. Install the Cognos TM1 API component and import the IBM Cognos TM1 certificate and create a property file that stores truststore password

  ---

  Reference: https://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.conn.tm1.usage.doc/top ics/tm1_installing_configuring.html

• Question 53:

  Which of the following locations will allow you to obtain a job's runtime logs? (Choose two.)

  A. Designer
  B. ISManager
  C. Workload Manager
  D. Operations Console
  E. Performance Monitor
  C. Workload Manager
  E. Performance Monitor

• Question 54:

  Consider a customer with multiple environments, Development, Test and Production. Which statement is TRUE?

  A. Each environment must have a C++ compiler.
  B. QualityStage rule sets are not a type of deployable asset.
  C. It is not possible to revert to a previous version of a package.
  D. A package can contain an improved version of a job which will replace the old one.
  B. QualityStage rule sets are not a type of deployable asset.

• Question 55:

  Which one of the following is an implicit data type conversion?

  A. date -> char
  B. char -> date
  C. varchar -> char
  D. char -> timestamp
  D. char -> timestamp

• Question 56:

  The Lookup stage is one of three stages that join records based on the values of key columns. What are the other stages? (Choose two.)

  A. Join
  B. Merge
  C. Modify
  D. Funnel
  E. Difference
  A. Join
  B. Merge

  ---

  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_Lookup_Stage.html

• Question 57:

  Given this configuration file:

  

  Which of the following describes the resulting behavior for a job consisting of Row Generator -> data set?

  A. Conductor, section leader and player processes are executed on the server is1 and is2.
  B. Conductor process is executed on the server is1. Section leader and Player processes are executed on the server is2.
  C. Conductor and section leader processes are executed on the server is1. Player processes are executed on the server is2.
  D. Conductor process and player processes are executed on the server is1. Section leader process is executed on the server is2.
  C. Conductor and section leader processes are executed on the server is1. Player processes are executed on the server is2.

• Question 58:

  Which type of data can be extracted using the Unstructured Data stage?

  A. XML data
  B. Microsoft Word data
  C. Microsoft Excel data
  D. BigInsights HDFS file data
  C. Microsoft Excel data

  ---

  Reference: https://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.ds.unstructureddatasta ge.usage.doc/topics/uds_extract_data.html

• Question 59:

  Which of the following is TRUE?

  A. The Modify stage can keep or drop records
  B. The DB2 Connector stage can have, at most, one input link
  C. The Copy stage can be used for implicit data type conversions
  D. When runtime column propagation is enabled, you can use output mapping on a stage to rename or drop columns
  D. When runtime column propagation is enabled, you can use output mapping on a stage to rename or drop columns

  ---

  Reference: https://www-01.ibm.com/support/knowledgecenter/SSZJPZ_9.1.0/com.ibm.swg.im.iis.conn.oracon.usage.doc/t opics/r_runtime_column_propagation.html (Useage).

• Question 60:

  Which of the following is TRUE about Transformer Stage when $APT_TRANSFORM_COMPILE_OLD_NULL_HANDLING is set?

  A. A Modify Operator is inserted at run time before a Transformer stage to handle null values
  B. If an input column that is used in the derivation expression of an output column contains a null value, then the resulting output column contains a null.
  C. If an input column that is used in the derivation expression of an output column contains a null value, then that row will be dropped or, if a reject link had been defined, rejected
  D. If an input column that is used in the derivation expression of an output column contains a null value, then the resulting output column will be calculated ignoring the Null value.
  C. If an input column that is used in the derivation expression of an output column contains a null value, then that row will be dropped or, if a reject link had been defined, rejected