Want to pass your IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 C2090-311 exam in the very first attempt? Try Pass2lead! It is equally effective for both starters and IT professionals.
VCE
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 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 table.
D. The addition of a primary key constraint to an empty column-organized table.