Which two sources can be used to provide input to the InfoSphere Optim Query Workload Tuner that generate EXPLAIN information when creating the query workload? A. db2pd B. Routines C. EXPLAIN tables D. Snapshot monitor E. ACTIVITIES event monitors

What formula can be used to determine the average number of column-organized pages found in each read request? A. POOL_COL_READS/ POOL COL READ REQS B. POOL_COL_P_READS/ POOL COL P READ REQS C. POOL_ASYNC_COL_READS/ POOL ASYNC COL READ REQS D. POOL…

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.…

Which command, when executed, will enable workload management for column-organized table workloads? A. db2setDB2_WORKLOAD=ANALYTICS B. db2set DB2_WLM_DISP_CONCUR=START C. UPDATE DBM CFG USING WLM_DISPATCHER YES D. UPDATE DBM CFG USING WORKLOAD TYPE ANALYTICAL

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

If the following commands are executed successfully: Which SQL statement will fail? A. Option A B. Option B C. Option C D. Option D

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

How is the Query Workload Tuner license installed and enabled? A. With Data Studio, using the license activation kit. B. By executing the db2licm command after data server installation. C. With the Optim Performance Manager Server, using the license activation…

Which scenario does NOT require intraquery parallelism? A. The execution of the LOAD command against an empty column-organized table. B. A DML operation that references a populated column-organized table. C. The execution of the RUNSTATS command against a populated column-organized…

Which type of compression is NOT provided as part of the DB2 Storage Optimization Feature? A. Row compression B. Index compression C. Backup compression D. Temporary table compression