If the DB2_WORKLOAD registry variable has not been set which database manager configuration parameter must be modified, before a query that accesses a column-organized table can be executed?

A. INTRA_PARALLEL

B. QUERY_HEAP_SZ

C. MAXIMUM DEGREE

D. SHEAPTHRES SHR

If the DB2_WORKLOAD registry variable is set to ANALYTICS, what value will be assigned to the DFT_DEGREE database configuration parameter, by default?

A. -1

B. 1

C. ON

D. ANY

By default, the Optim Workload Table Organization Advisor will recommend converting row- organized tables to column-organized tables if it determines that the change will improve query performance, as a whole, by how much?

A. 15 percent

B. 20 percent

C. 25 percent

D. 30 percent

What is a DB2 Advanced Copy Services (ACS) script used for?

A. To install and configure DB2 Advanced Copy Services.

B. To redirect Tivoli Storage FlashCopy Manager commands to DB2 Advanced Copy Services.

C. To test the functionality of a DB2 ACS API vendor library without performing a snapshot backup or restore operation.

D. To perform snapshot backup and restore operations on storage devices that do not have a DB2 ACS API vendor library.

What will cause the creation of a column-organized table to fail?

A. Setting the database code set to UNICODE.

B. Setting the DFT_DEGREE database configuration parameter to ANY.

C. Setting the AUTO_RUNSTATS database configuration parameter to ON.

D. Setting the UTILJHEAP_SZ database configuration parameter to at least 1.000,000 pages.

In which type of database are column-organized tables supported?

A. Partitioned databases.

B. DB2 pureScale databases.

C. Databases whose code set is Unicode.

D. Databases whose code set is Non-Unicode.

If Self Tuning Memory Manager (STMM) is enabled for a DB2 10.5, FixPack 1 pureScale database, which two capabilities are available?

A. Multi-tenancy

B. Workload consolidation

C. Independent tuning member

D. Broadcasting STMM tuning decisions to all members

E. Single INSTANCE_MEMORY instance configuration memory setting

Which monitoring function can be used to determine how many times an SQL statement has referenced a particular column-organized table within a specific period of time?

A. MON_GET_TABLE()

B. MON_GET_TABLESPACE()

C. MON_GET_UNIT_OF_WORK()

D. MON_GET_TABLE_USAGE_LIST()

When can a high availability disaster recovery (HADR) role switch operation be performed in a DB2 pureScale environment?

A. When crash recovery is occurring on the standby cluster.

B. When all the log streams are in peer or assisted remote catchup state.

C. When the primary database is not connected to the standby database.

D. All the log streams are in remote catchup state and the synchronization mode is NEARASYNC.

What type of table can be converted into a column-organized table with the db2convert command?

A. A range partitioned table

B. A materialized query table

C. A row-organized user table

D. A declared global temporary table