IBM C2090-614 Online Practice Questions and Exam Preparation

IBM C2090-614 Online Questions & Answers

• Question 1:

  When defining storage groups for multi-temperature data, storage paths are usually grouped according to their quality of service characteristics. What are three common quality of service characteristics used?

  A. Frequency of access; acceptable access time; volatility of the data.
  B. Acceptable access time; redundancy of the data; volatility of the data.
  C. TIR (table/index data ratio); frequency of access; volatility of the data;
  D. Frequency of access; redundancy of the data; acceptable access time;
  A. Frequency of access; acceptable access time; volatility of the data.

• Question 2:

  Which Workload Manager (WLM) objects can the COLLECT ACTIVITY DATA clause be used with?

  A. Data class, work class, and a limit
  B. Data class, action class, and a threshold
  C. Service subclass, action class, and a limit
  D. Service subclass, work class, and a threshold
  D. Service subclass, work class, and a threshold

• Question 3:

  Which Workload Manager (WLM) objects can the COLLECT ACTIVITY DATA clause be used with?

  A. Data class, work class, and a limit
  B. Data class, action class, and a threshold
  C. Service subclass, action class, and a limit
  D. Service subclass, work class, and a threshold
  D. Service subclass, work class, and a threshold

• Question 4:

  Which is NOT a valid method for prefetching data?

  A. Smart data prefetching
  B. Read-ahead prefetching
  C. Consecutive prefetching
  D. Sequential detection prefetching
  C. Consecutive prefetching

• Question 5:

  Which statement about IBM WebSphere Information Integrator Q Replication is correct?

  A. It reads the DB2 recovery log and stores committed transactional data in staging tables.
  B. It reads the DB2 recovery log and converts committed transactional data to SQL statements.
  C. It provides the lowest latency of data in the target databases and lowest throughput of changed data to the target databases.
  D. It provides the lowest latency of data in the target databases and highest throughput of changed data to the target databases.
  D. It provides the lowest latency of data in the target databases and highest throughput of changed data to the target databases.

• Question 6:

  A table named MYTAB was created as follows:

  

  How many rows will be inserted into the MYTAB table?

  A. 4
  B. 8
  C. 11
  D. 12
  B. 8

• Question 7:

  A storage group named HOT_SG was created as follows:

  

  What does the DATA TAG 1 clause do?

  A. It indicates that the multiple storage paths referenced in the HOT_SG storage group definition exist in one physical location.
  B. It tells the DB2 Optimizer that database objects stored in the HOT_SG storage group are to be given preference over other objects when data access plans are generated.
  C. It indicates that the value 1 is to be assigned to data stored in the HOT_SG storage group, which Workload Manager (WLM) can then use to determine the processing priority to assign to database activities that interact with this data.
  D. It assigns a unique identifier to the instance of the HOT_SG storage group being defined; this identifier can then be used when moving table spaces to and from the storage group, when dropping the storage group, or when commenting on the storage group.
  C. It indicates that the value 1 is to be assigned to data stored in the HOT_SG storage group, which Workload Manager (WLM) can then use to determine the processing priority to assign to database activities that interact with this data.

• Question 8:

  If the AUDIT_BUF_SZ configuration parameter is set to zero (0), what will happen?

  A. The audit facility writes records to disk at the same time the statements generating the audit records are executing.
  B. Statements generating audit records must wait for the records to be written to disk before they can complete execution.
  C. The writing of audit records to disk will be delayed until a minimum number of records (based on record size and memory available in the database heap) have been generated.
  D. There is no limit to how many audit records can be stored in an internal memory buffer for one single statement generating audit records.
  B. Statements generating audit records must wait for the records to be written to disk before they can complete execution.

• Question 9:

  Which statement about compression dictionaries is FALSE?

  A. Page-level dictionaries are stored in hidden rows within the table.
  B. Table-level dictionaries are stored in hidden rows within the table.
  C. Page-level dictionaries are automatically created or recreated by the database manager as pages are filled.
  D. Table-level dictionaries are automatically created or recreated as by the database manager as pages are filled.
  D. Table-level dictionaries are automatically created or recreated as by the database manager as pages are filled.

• Question 10:

  Which monitoring tool can be used to obtain stripe set information for database managed storage table spaces?

  A. The MON_GET_CONTAINER table function.
  B. The SNAP_GET_TBSP_PART table function.
  C. The SNAPTBSP_RANGE administrative view.
  D. The TS_GET_CONTAINER administrative view.
  A. The MON_GET_CONTAINER table function.