IBM Assessment: DB2 10.1 Advanced DBA for LUW 認定 A2090-614 試験問題:

1. In which scenario should a DBA consider creating a multidimensional clustering (MDC) table instead of a regular base table?

A) To improve access performance for tables in an OLTP database.
B) To improve query performance in a data warehouse environment.
C) To improve insert/delete performance for tables in an OLTP database.
D) To improve index performance in a data warehouse environment.

2. Consider the following statement:

Which indexes should be created for optimal query performance?

A) CREATE INDEX emp_idx ON employee (lastname, job, workdept) CLUSTER; CREATE INDEX dept_idx ON department (deptname);
B) CREATE INDEX emp_idx ON employee (workdept, lastname, job); CREATE INDEX dept_idx ON department (deptname, deptno);
C) CREATE INDEX emp_idx ON employee (workdept) CLUSTER; CREATE INDEX dept_idx ON department (deptname, deptno);
D) CREATE INDEX emp_idx ON employee (workdept); CREATE INDEX dept_idx ON department (deptno);

3. 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 TS_GET_CONTAINER administrative view.
C) The SNAP_GET_TBSP_PART table function.
D) The SNAPTBSP_RANGE administrative view.

4. What is a benefit of multi-temperature data storage?

A) It helps reduce redundant I/O.
B) It helps reduce storage costs for infrequently accessed data.
C) It helps identify data access patterns to aid in storage planning.
D) It helps improve data compression ratios.

5. What must you do before an online table space backup operation can be performed?

A) Set the DB2_ENABLE_ONLINEBKUP registry variable to ON.
B) Create an incremental backup image of the table space.
C) Create one or more tables in the table space.
D) Create a full database backup image.

質問と回答：