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

• Question 1:

  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.

  Correct Answer: B

• Question 2:

  After starting a series of LOAD operations it appears that one LOAD is failing. What diagnostic tool would you use to determine which LOAD operation is being problematic?

  A. db2pd

  B. db2dart

  C. db2fodc

  D. db2ls

  Correct Answer: A

• Question 3:

  In which situation would you NOT use a redirected restore?

  A. To redefine the paths of a defined storage group.

  B. To move table space containers onto different physical devices.

  C. To restore a backup image from one operating system to another.

  D. To restore a backup image to a target machine that is different from the source machine.

  Correct Answer: C

• Question 4:

  In what situation should you use a redirected restore operation?

  A. You want to drop a storage group during a restore process.

  B. You want to move data from one operating system to another.

  C. You want to restore you table spaces into new storage groups.

  D. You want to restore your table space containers into a different physical location.

  Correct Answer: D

• Question 5:

  You need to restore a table space that was backed up earlier, but before you begin a restore operation you want to determine whether any tables in the table space were populated with a LOAD ... NONRECOVERABLE operation. What can be used to provide this information?

  A. The INSPECT utility

  B. The db2pd command

  C. The db2dart command

  D. The database recovery history file

  Correct Answer: D

• Question 6:

  Which diagnostic tool can be used to show high-watermark consumptions of Fast Communication Manager (FCM) buffers and channels?

  A. db2pd

  B. inspect

  C. db2dart

  D. db2mtrk

  Correct Answer: A

• Question 7:

  Prior to migrating to DB2 10.1, a DBA executed the following command on a daily basis:

  db2_all "<<-1< db2 BACKUP DATABASE sales TO /mnt/backup" Which command can now be used to perform the same backup operation?

  A. BACKUP DATABASE sales ON DBPARTITIONNUM (1) TO /mnt/backup

  B. BACKUP DATABASE sales ON ALL DBPARTITIONNUMS TO /mnt/backup

  C. BACKUP DATABASE sales ON ALL DBPARTITIONNUMS EXCEPT CATPARTITION TO /mnt/backup

  D. BACKUP DATABASE sales ON ALL DBPARTITIONNUMS EXCEPT DBPARTITIONNUM (1) TO /mnt/backup

  Correct Answer: D

• Question 8:

  Which configuration parameter is used to designate a storage area for archived log files that are retrieved for recovery purposes?

  A. logarchopt1

  B. failarchpath

  C. mirrorlogpath

  D. overflowlogpath

  Correct Answer: D

• Question 9:

  What is the default user workload class that is created for each database table?

  A. DEFAULT_USER

  B. SYSUSERDEFAULTWLM

  C. SYSDEFAULTUSERWORKLOAD

  D. SYS_DEFAULT_USER_WORKLOAD

  Correct Answer: C

• Question 10:

  With HADR, IBM Tivoli System Automation for Multiplatforms (SA MP) automated failover can be used with which database(s)?

  A. The primary database only.

  B. The auxiliary standby database only.

  C. The principal standby database only.

  D. The primary, auxiliary standby, and principal standby database.

  Correct Answer: C