We provide real C2090-311 exam questions and answers braindumps in two formats. Download PDF & Practice Tests. Pass IBM C2090-311 Exam quickly & easily. The C2090-311 PDF type is available for reading and printing. You can print more and practice many times. With the help of our IBM C2090-311 dumps pdf and vce product and material, you can easily pass the C2090-311 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
Q11. Which statement about column-organized tables is true?
A. Databases with column-organized tables can be federated.
B. Schemas that include column-organized tables can be transported.
C. Sort memory can be automatically tuned in environments containing column-organized tables.
D. Queries that use the Currently Committed semantics can be used with column-organized tables.
Answer: A
Q12. 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
Answer: D,E
Q13. 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
Q14. 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.
Answer: A
Q15. What will cause the creation of a column-organized table to fail?
A. Setting the database code set to UNICODE.
B. Setting the DFT_DEGREE database configuration parameter to ANY.
C. Setting the AUTO_RUNSTATS database configuration parameter to ON.
D. Setting the UTILJHEAP_SZ database configuration parameter to at least 1.000,000 pages.
Answer: C
Q16. When can a high availability disaster recovery (HADR) role switch operation be performed in a DB2 pureScale environment?
A. When crash recovery is occurring on the standby cluster.
B. When all the log streams are in peer or assisted remote catchup state.
C. When the primary database is not connected to the standby database.
D. All the log streams are in remote catchup state and the synchronization mode is NEARASYNC.
Answer: D
Q17. If the DB2_WORKLOAD registry variable is set to ANALYTICS, what value will be assigned to the DFT_DEGREE database configuration parameter, by default?
A. -1
B. 1
C. ON
D. ANY
Answer: A
Q18. 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