IBM IBM Certified Advanced Database Administrator C2090-614 Questions & Answers

• Question 91:

  Which diagnostic tool can be used to collect metrics on individual SQL statement executions?

  A. db2dart

  B. A snapshot monitor

  C. A statement event monitor

  D. The MON_GET_UNIT_OF_WORK_DETAILS table function

  Correct Answer: C

• Question 92:

  Which statement about DB2 Merge Backup is FALSE?

  A. It can be used to merge offline backups to build full offline table space backups.

  B. It can be used to merge SNAPSHOT and TSM tape backup images to create a full database backup image.

  C. It can be used merge multiple offline database backups to build a cumulative single offline database backup.

  D. It can be used to merge backups on a machine that is different from the machine where the backup has been created in stand-alone mode.

  Correct Answer: B

• Question 93:

  What is the recommended method for removing old backup images and log files for a DB2 10.1 database?

  A. Manually delete old backups and logs.

  B. Utilize the PRUNE LOGFILE PRIOR TO command to remove old backups and logs.

  C. Utilize the PRUNE HISTORY AND DELETE command to remove old backups and logs.

  D. Set the DB2PRUNE_ACTION_LOG configuration parameter to a desired date before generating a new backup.

  Correct Answer: C

• Question 94:

  An auxiliary HADR standby database must use which HADR sync mode?

  A. SYNC

  B. ASYNC

  C. NEARSYNC

  D. SUPERASYNC

  Correct Answer: D

• Question 95:

  What is the FAILARCHPATH database configuration parameter used for?

  A. To specify a path that DB2 will use to look for archive log files that are needed for a rollforward recovery operation.

  B. To specify a path to which DB2 will attempt to store a copy of archive log files to protect against accidental deletion.

  C. To specify a path to which DB2 will attempt to store a copy of both active and archive log files to protect against disk failure and power outages.

  D. To specify a path to which DB2 will attempt to store archive log files if they cannot be written to the primary or secondary archive destination because of a media problem.

  Correct Answer: D

• Question 96:

  The following query is executed frequently against the SALES table:

  SELECT sales_person, region FROM sales WHERE region = 'Quebec' Which statement will create an index for optimal query performance?

  A. CREATE INDEX sales_idx ON sales (region)

  B. CREATE INDEX sales_idx ON sales (sales_person)

  C. CREATE INDEX sales_idx ON sales (region, sales_person)

  D. CREATE INDEX sales_idx ON sales (region) INCLUDE (sales_person)

  Correct Answer: C

• Question 97:

  Which monitoring tool can be used to find out how many data pages have been read from the table space containers for regular, large, and temporary table spaces?

  A. The MON_DB_SUMMARY administrative view.

  B. The MON_BP_UTILIZATION administrative view.

  C. The MON_GET_ACTIVITY_DETAILS table function.

  D. The MON_GET_EXTENT_MOVEMENT_STATUS table function.

  Correct Answer: B

• Question 98:

  What advantage do block-based buffer pools offer compared to regular buffer pools?

  A. They improve the performance of sequential prefetching by reading contiguous pages from disk and writing them into contiguous pages in a buffer pool.

  B. They improve the performance of random I/O by reading non-contiguous pages from disk and writing them into near-contiguous free space in a buffer pool.

  C. They improve the performance of vectored reads by retrieving non-contiguous pages from disk, combining them into extent-sized blocks, and writing the blocks into contiguous pages in a buffer pool.

  D. They improve the performance of scattered writes by retrieving non-contiguous pages from a buffer pool, combining them into extent-sized blocks, and writing the blocks into contiguous pages on disk.

  Correct Answer: A

• Question 99:

  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.

  Correct Answer: D

• Question 100:

  Which statement about value compression is correct?

  A. To use value compression, you must have a license for the DB2 Storage Optimization Feature.

  B. Value compression uses a page-level dictionary-based compression algorithm to compress data based on repetition of values found in a single column.

  C. Value compression involves removing duplicate entries for a value, only storing one copy, and keeping track of the location of any references to the stored copy.

  D. When value compression is used, the byte count of compressed NULLs, zeros, and blanks might be larger than that of the uncompressed version of the same values.

  Correct Answer: C