File Info
| Exam | IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 |
| Number | C2090-311 |
| File Name | IBM.C2090-311.TestKing.2019-02-20.30q.vcex |
| Size | 114 KB |
| Posted | Feb 20, 2019 |
| Download | IBM.C2090-311.TestKing.2019-02-20.30q.vcex |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
How is the Query Workload Tuner license installed and enabled?
- With Data Studio, using the license activation kit.
- By executing the db2licm command after data server installation.
- With the Optim Performance Manager Server, using the license activation kit.
- 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?
- INTRA_PARALLEL
- QUERY_HEAP_SZ
- MAXIMUM DEGREE
- SHEAPTHRES SHR
Correct answer: A
Question 3
If the following commands are executed successfully:
Which SQL statement will fail?
- Option A
- Option B
- Option C
- Option D
Correct answer: C
Question 4
Which command, when executed, will enable workload management for column-organized table workloads?
- db2setDB2_WORKLOAD=ANALYTICS
- db2set DB2_WLM_DISP_CONCUR=START
- UPDATE DBM CFG USING WLM_DISPATCHER YES
- 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
- ON
- 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?
- 15 percent
- 20 percent
- 25 percent
- 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?
- POOL_COL_READS/POOL COL READ REQS
- POOL_COL_P_READS/POOL COL P READ REQS
- POOL_ASYNC_COL_READS/POOL ASYNC COL READ REQS
- 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?
- db2pd
- Routines
- EXPLAIN tables
- Snapshot monitor
- ACTIVITIES event monitors
Correct answer: CD
Question 9
Which type of compression is typically used with column-organized tables?
- BLU compression
- Value compression
- Actionable compression
- Adaptive row compression
Correct answer: A
Question 10
Which statement about column-organized tables is true?
- Databases with column-organized tables can be federated.
- Schemas that include column-organized tables can be transported.
- Sort memory can be automatically tuned in environments containing column-organized tables.
- Queries that use the Currently Committed semantics can be used with column-organized tables.
Correct answer: A
