IBM IBM Certifications C2090-424 Questions & Answers

• Question 11:

  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

  Correct Answer: D

• Question 12:

  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

  Correct Answer: A

• Question 13:

  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

  Correct Answer: D

• Question 14:

  Which Slowly Changing Dimension (SCD) stage statement is TRUE?

  A. Surrogate keys are used to join a dimension table to a fact table in a normalized schema database

  B. Each SCD stage processes multiple dimensions and performs lookups by using an equality matching

  C. Purpose codes are part of the table metadata that the SCD stage propagates to the dimension insert link.

  D. Actual dimensions changes are applied to the lookup table in memory and are mirrored to the dimension update link

  Correct Answer: B

• Question 15:

  A Parameter Set is a named object that can contain which of the following?

  A. Multiple parameters and only one value file

  B. Only one parameter and only one value file

  C. Multiple parameters and multiple value files

  D. Only one parameter and multiple value files

  Correct Answer: D

• Question 16:

  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

  Correct Answer: C

• Question 17:

  Your job aggregates data before writing the results out to a DB2 table. You have since learned that this job will be required to aggregate very large amounts of data. To ensure high performance you create a new, non-default configuration file for the job that defines a node pool named "highperfnodes" that includes only nodes with very high processing power.

  What additional design changes do you need to make to the job to ensure that it aggregates the data using the "highperfnodes" pool? (Choose two.)

  A. Select the "highperfnodes" pool in the Execution tab of the Job Properties window

  B. Add the $APT_CONFIG_FILE environment variable as an additional job parameter

  C. Add a Sort stage before the Aggregator stage to sort the data before the data is aggregated

  D. Change properties in the Aggregator stage to force it to use the nodes in the appropriate pool

  E. Change properties in the Aggregator stage to force it to use the new non-default configuration file

  Correct Answer: AD

• Question 18:

  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

  Correct Answer: D

• Question 19:

  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

  Correct Answer: CE

• Question 20:

  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

  Correct Answer: C