C2090-311 Online Practice Questions and Answers

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

D. By running the Query Workload Tuner license activation command on the appropriate WebSphere server.

If the following commands are executed successfully:

Which SQL statement will fail?

A. Option A

B. Option B

C. Option C

D. Option D

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

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

Which type of compression is typically used with column-organized tables?

A. BLU compression

B. Value compression

C. Actionable compression

D. Adaptive row compression

What does the monitor element POOL_FAILED_ASYNC_TEMP_COL_REQS track?

A. The number of times an attempt to queue a column-organized prefetch request for temporary table spaces was made but failed.

B. The number of times a temporary error occurred while trying to queue a column-organized prefetch request for a regular table space.

C. The number of times DB2 had to retrieve a page from disk for a temporary column-organized table because the page no longer resided in the buffer pool.

D. The number of times an asynchronous read request failed when attempting to read temporary column-organized data from the buffer pool after the page had been flushed to disk.

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

What happens when the STATISTICS USE PROFILE option is provided with a LOAD command that will be used to populate a column-organized table and a statistics profile does not exist?

A. A warning is returned and no statistics are collected.

B. An error is returned and the table is placed in "load pending" state.

C. A statistics profile is automatically generated before the load is allowed to continue.

D. The Load utility uses the same RUNSTATS command options as those used during an automatic runstats operation.

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