Master the C2090-311 IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 content and be ready for exam day success quickly with this Examcollection C2090-311 practice question. We guarantee it!We make it a reality and give you real C2090-311 questions in our IBM C2090-311 braindumps.Latest 100% VALID IBM C2090-311 Exam Questions Dumps at below page. You can use our IBM C2090-311 braindumps and pass your exam.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-311 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-311 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-311-exam-dumps.html
Q1. When does space reclamation for a column-organized table normally occur?
A. Whenever an individual row is deleted.
B. Whenever an individual row is updated.
C. After all rows in an extent have been updated.
D. After all rows in an extent where updates took place have been deleted.
Answer: A
Q2. 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
Answer: B
Q3. 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
Answer: C
Q4. 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.
IBM C2090-311 : Practice Test
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.
Answer: B
Q5. Which two HADR synchronization modes are supported in DB2 10.5 pureScale environments?
A. SYNC
B. ASYNC
C. NEARSYNC
D. SUPERSYNC
E. SUPERASYNC
Answer: B,C
Q6. What are the correct steps to capture EXPLAIN information for column-organized tables?
A. 1. Issue the query against column-organized tables 2.Execute the db2exfmt command
B. 1. Execute the command CURRENT EXPLAIN MODE YES
2.Issue the query against column-organized tables
3.Execute the db2exfmt command
C. 1. Set the ENABLE_COLUMN_TABLES registry variable to YES
2.Issue the query against column-organized tables
3.Execute the db2exfmt command
D. 1. Set the ENABLE_COLUMN_TABLES registry variable to YES
2.Execute the command CURRENT EXPLAIN MODE YES
3.Issue the query against column-organized tables
4.Execute the db2exfmt command
Answer: D
Q7. If the following commands are executed successfully:
Which SQL statement will fail?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: C
Q8. 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
Answer: C,D
Q9. Which command would be used to finish a rolling FixPack update to a two member DB2 pureScale cluster?
A. db2iupdt-a
B. db2iupdt-update
C. db2iupdt-commit_level
D. db2iupdt-online_update
Answer: B
Q10. 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.
Answer: A