IBM C2090-303 Online Practice Questions and Exam Preparation

IBM C2090-303 Online Questions & Answers

• Question 41:

  When using Runtime Column Propagation, which two stages require a schema file? (Choose two.)

  A. Peek stage
  B. Pivot stage
  C. Column Import stage
  D. DB2 Connector stage
  E. Sequential File stage
  C. Column Import stage
  E. Sequential File stage

• Question 42:

  What are two statistics or attributes that can be added to the output of a Data Rule stage? (Choose two.)

  A. Record ID
  B. System timestamp
  C. Number of violations
  D. Job execution owner
  E. Percentage of violations
  A. Record ID
  B. System timestamp

• Question 43:

  What two repositories does the Source Code Control Integration for DataStage and QualityStage serve? (Choose two.)

  A. WebSphere Repository
  B. Source Code Repository
  C. Universe Project Repository
  D. Information Analyzer Repository
  E. Information Server metadata Repository
  B. Source Code Repository
  E. Information Server metadata Repository

• Question 44:

  The parallel framework supports standard and complex data types in the SQL type column tab property. Identify the two complex data types? (Choose two.)

  A. Vector
  B. VarChar
  C. Linked list
  D. Subrecord
  E. Binary trees
  A. Vector
  D. Subrecord

• Question 45:

  Which two statements are true about the use of named node pools? (Choose two.)

  A. Grid environments must have named node pools for data processing.
  B. Named node pools can allow separation of buffering from sorting disks.
  C. When named node pools are used, DataStage uses named pipes between stages.
  D. Named node pools limit the total number of partitions that can be specified in the configuration file.
  E. Named node pools constraints will limit stages to be executed only on the nodes defined in the node pools.
  B. Named node pools can allow separation of buffering from sorting disks.
  E. Named node pools constraints will limit stages to be executed only on the nodes defined in the node pools.

• Question 46:

  Which option is required to identify a particular job player processes?

  Which option is required to identify a particular job? player processes?

  A. Set $APT_DUMP_SCORE to true.
  B. Set $APT_PM_SHOW_PIDS to true.
  C. Log onto the server and issue the command "ps -ef | grep ds".
  D. Use the DataStage Director Job administration screen to display active player processes.
  B. Set $APT_PM_SHOW_PIDS to true.

• Question 47:

  Which requirement must be met to read from a database in parallel using the ODBC connector?

  A. ODBC connector always reads in parallel.
  B. Set the Enable partitioning property to Yes.
  C. Configure environment variable $APT_PARTITION_COUNT.
  D. Configure environment variable $APT_MAX_TRANSPORT_BLOCK_SIZE.
  B. Set the Enable partitioning property to Yes.

• Question 48:

  In addition to the table and schema names, what two element names must be specified when you create a shared table definition in DataStage Designer? (Choose two.)

  A. Database
  B. Project name
  C. Host system
  D. Database instance
  E. DataStage server system name
  A. Database
  C. Host system

• Question 49:

  What is the purpose of the APT_DUMP_SCORE environment variable?

  A. There is no such environment variable.
  B. It is an environment variable that turns on the job monitor.
  C. It is an environment variable that enables the collection of runtime performance statistics.
  D. It is a reporting environment variable that adds additional runtime information in the job log.
  D. It is a reporting environment variable that adds additional runtime information in the job log.

• Question 50:

  Your job is using the Sequential File stage as a source. Identify two stage property configurations that will allow you to accomplish parallel reads? (Choose two.)

  A. Read Method property set to 'File Pattern' and the environment variable $APT_IMPORT_PATTERN_USES_FILESET is set to 'FALSE'.
  B. Read Method property set to 'File Pattern' and the 'Readers per Node' property value set to greater than 1.
  C. Read Method property is set to 'Parallel' with the Key property set to a Input column that has the file names.
  D. Read Method property set to 'Specific File(s)' with only one file specified and the 'Readers Per Node' property value set to greater than 1.
  E. Read Method property set to 'Specific File(s)' with more than one file specified and each file specified has the same format/column properties.
  D. Read Method property set to 'Specific File(s)' with only one file specified and the 'Readers Per Node' property value set to greater than 1.
  E. Read Method property set to 'Specific File(s)' with more than one file specified and each file specified has the same format/column properties.