Download IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1.C2090-311.TestKing.2019-02-20.30q.vcex

Vendor: IBM
Exam Code: C2090-311
Exam Name: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1
Date: Feb 20, 2019
File Size: 114 KB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
How is the Query Workload Tuner license installed and enabled?
  1. With Data Studio, using the license activation kit.
  2. By executing the db2licm command after data server installation.
  3. With the Optim Performance Manager Server, using the license activation kit.
  4. By running the Query Workload Tuner license activation command on the appropriate WebSphere server.
Correct answer: A
Question 2
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?
  1. INTRA_PARALLEL
  2. QUERY_HEAP_SZ
  3. MAXIMUM DEGREE
  4. SHEAPTHRES SHR
Correct answer: A
Question 3
If the following commands are executed successfully:
  
Which SQL statement will fail? 
  
  1. Option A
  2. Option B
  3. Option C
  4. Option D
Correct answer: C
Question 4
Which command, when executed, will enable workload management for column-organized table workloads?
  1. db2setDB2_WORKLOAD=ANALYTICS
  2. db2set DB2_WLM_DISP_CONCUR=START
  3. UPDATE DBM CFG USING WLM_DISPATCHER YES
  4. UPDATE DBM CFG USING WORKLOAD TYPE ANALYTICAL
Correct answer: C
Question 5
If the DB2_WORKLOAD registry variable is set to ANALYTICS, what value will be assigned to the DFT_DEGREE database configuration parameter, by default?
  1. -1
  2. 1
  3. ON
  4. ANY
Correct answer: A
Question 6
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?
  1. 15 percent
  2. 20 percent
  3. 25 percent
  4. 30 percent
Correct answer: B
Question 7
What formula can be used to determine the average number of column-organized pages found in each read request?
  1. POOL_COL_READS/ 
    POOL COL READ REQS
  2. POOL_COL_P_READS/ 
    POOL COL P READ REQS
  3. POOL_ASYNC_COL_READS/ 
    POOL ASYNC COL READ REQS
  4. POOL ASYNC COL P READS/POOL ASYNC COL P READ REQS
Correct answer: A
Question 8
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?
  1. db2pd
  2. Routines
  3. EXPLAIN tables
  4. Snapshot monitor
  5. ACTIVITIES event monitors
Correct answer: CD
Question 9
Which type of compression is typically used with column-organized tables?
  1. BLU compression
  2. Value compression
  3. Actionable compression
  4. Adaptive row compression
Correct answer: A
Question 10
Which statement about column-organized tables is true?
  1. Databases with column-organized tables can be federated.
  2. Schemas that include column-organized tables can be transported.
  3. Sort memory can be automatically tuned in environments containing column-organized tables.
  4. Queries that use the Currently Committed semantics can be used with column-organized tables.
Correct answer: A
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!