C2090-614

C2090-614 practice questions, page 3 of 5, with answer review and explanations.

Question 11

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

  1. They improve the performance of sequential prefetching by reading contiguous pages from disk and writing them into contiguous pages in a buffer pool.
  2. 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.
  3. 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.
  4. They improve the performance of scattered writes by retrieving non-contiguous pages from a buffer pool, combining them into extent-sized blocks, and writing

Question 12

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?

  1. CREATE INDEX sales_idx ON sales (region)
  2. CREATE INDEX sales_idx ON sales (sales_person)
  3. CREATE INDEX sales_idx ON sales (region, sales_person)
  4. CREATE INDEX sales_idx ON sales (region) INCLUDE (sales_person)

Question 13

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?

  1. The MON_DB_SUMMARY administrative view.
  2. The MON_BP_UTILIZATION administrative view.
  3. The MON_GET_ACTIVITY_DETAILS table function.
  4. The MON_GET_EXTENT_MOVEMENT_STATUS table function.

Question 14

What is the FAILARCHPATH database configuration parameter used for?

  1. To specify a path that DB2 will use to look for archive log files that are needed for a roll forward recovery operation.
  2. To specify a path to which DB2 will attempt to store a copy of archive log files to protect against accidental deletion.
  3. 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.
  4. 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

Question 15

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

  1. SYNC
  2. ASYNC
  3. NEARSYNC
  4. SUPERASYNC