IBM IBM Certifications C2090-424 Questions & Answers

• Question 41:

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

  A. Integer

  B. Double

  C. VarChar

  D. Decimal

  Correct Answer: B

• Question 42:

  Which of the following is TRUE about working with assets and artifacts?

  A. Rational Team Connect is not supported at all

  B. Information Server Manager has no logging capability

  C. You cannot lock and unlock assets in Rational Team Concert, regardless of tool used

  D. You must import the source control project into your own source control workspace in Information Server Manager before you can submit assets

  Correct Answer: D

• Question 43:

  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.

  Correct Answer: C

• Question 44:

  Which of the following environment variables can help in verifying whether data is evenly partitioned across all nodes?

  A. $OSH_PRINT_SCHEMAS

  B. $APT_RECORD_COUNTS

  C. $APT_PARTITION_COUNT

  D. $APT_DEBUG_OPERATOR

  Correct Answer: A

• Question 45:

  Which statement about looping in sequences is TRUE?

  A. The Start Loop stage only supports numeric loops

  B. Numeric loops must increment by one unless you supply a parameter

  C. The current loop counter value can be passed to the stages in the loop

  D. The compiler will insert an End Loop as the last stage in the sequence if one is omitted

  Correct Answer: C

• Question 46:

  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

  Correct Answer: C

• Question 47:

  Which statement is TRUE about Balanced Optimization?

  A. Balanced Optimization is installed with InfoSphere DataStage.

  B. Balanced Optimization creates a parameter set called BalOpJAQLParams in the underlying project if it does not exist.

  C. Balanced Optimization will change or optimize machine configurations, InfoSphere DataStage configurations, database configurations, or HDFS configurations.

  D. Balanced optimizations are performed in a priority order. When there is ambiguity (for example, some

  processing could be performed either in a source or target database) processing is pushed into database sources.

  Correct Answer: D

• Question 48:

  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

  Correct Answer: C

• Question 49:

  Which statement about the ISD input stage is NOT TRUE?

  A. A job must have zero or one ISD input stages

  B. A job with an ISD input stage must have an ISD output stage

  C. Buffer size and timeout values can be supplied as job parameters

  D. Text over JMS binding is only available if you are using Network Deployment

  Correct Answer: D

• Question 50:

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

  A. date -> char

  B. char -> date

  C. varchar -> char

  D. char -> timestamp

  Correct Answer: D