DB2 10.1 Advanced DBA for Linux UNIX and Windows: C2090-614

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

Which statement about Range-Clustered Tables (RCTs) is correct?

A. More logging is required compared to similarly-sized regular tables.

B. More buffer pool memory is required to store the table's B+ index structure.

C. Space is pre-allocated and reserved for use by the table even when records do not yet exist.

D. More maintenance is required since indexes must be updated after every insert, update, or delete operation.

A query against the system catalog revealed that data for a table named SALES in a partitioned database is distributed as follows:

What can be done to improve the performance of a query that joins SALES and DATE_DIM tables (where SALES is a fact table and DATE_DIM is a dimension table) using the DATE_ID column?

A. Reload table SALES and use only one partition with a collocated join to the DATE_DIM table using the primary key DATE_ID

B. Reload table DATE_DIM and use only one partition with a collocated join to the SALES table using the primary key DATE_ID

C. Create a replicated table REPL_SALES from the SALES table, refresh REPL_SALES table, create index on DATE_ID column in the REPL_SALES table, and collect statistics on REPL_SALES table.

D. Create a replicated table REPL_DATE_DIM from the DATE_DIM table, refresh REPL_DATE_DIM table, create index on DATE_ID column in the REPL_DATE_DIM table, and collect statistics on REPL_DATE_DIM table.