C2090-614

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

Question 16

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

  1. Manually delete old backups and logs.
  2. Utilize the PRUNE LOGFILE PRIOR TO command to remove old backups and logs.
  3. Utilize the PRUNE HISTORY AND DELETE command to remove old backups and logs.
  4. Set the DB2PRUNE_ACTION_LOG configuration parameter to a desired date before generating a new backup.

Question 17

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

  1. db2dart
  2. A snapshot monitor
  3. A statement event monitor
  4. The MON_GET_UNIT_OF_WORK_DETAILS table function

Question 18

Which statement about DB2 Merge Backup is FALSE?

  1. It can be used to merge offline backups to build full offline table space backups.
  2. It can be used to merge SNAPSHOT and TSM tape backup images to create a full database backup image.
  3. It can be used merge multiple offline database backups to build a cumulative single offline database backup.
  4. 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.

Question 19

What two types of information can be obtained with the MON_GET_TABLESPACE monitor table function? (Choose two.)

  1. Table space available space
  2. Table space read and write activity
  3. Table space container assignments
  4. Table level activity within a table space
  5. Table space backup and recovery information

Question 20

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

  1. Data class, work class, and a limit
  2. Data class, action class, and a threshold
  3. Service subclass, action class, and a limit
  4. Service subclass, work class, and a threshold