we provide Practical IBM C2090-614 free download which are the best for clearing C2090-614 test, and to get certified by IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows (C2090-614). The C2090-614 Questions & Answers covers all the knowledge points of the real C2090-614 exam. Crack your IBM C2090-614 Exam with latest dumps, guaranteed!
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-614 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-614 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-614-exam-dumps.html
Q21. A table named MYTAB was created as follows:
How many rows will be inserted into the MYTAB table?
A. 4
B. 8
C. 11
D. 12
Answer: B
Q22. Which statement about Insert-Time-Clustered (ITC) is correct?
A. Views cannot be created on ITC tables.
B. ITC tables do not support row compression.
C. Block indexes cannot be created for ITC tables.
D. ITC tables can release their empty pages to the operating system.
Answer: C
Q23. In what situation should you use a redirected restore operation?
A. You want to drop a storage group during a restore process.
B. You want to move data from one operating system to another.
C. You want to restore you table spaces into new storage groups.
D. You want to restore your table space containers into a different physical location.
Answer: D
Q24. If a large amount of sequential prefetching is occurring, what can be done to improve efficiency?
A. Set SEQDETECT to NO.
B. Set NUMBLOCKPAGES to 0 in all buffer pools.
C. Allocate a block-based area in the appropriate buffer pool.
D. Create indexes that encourage the optimizer to use index-only access.
Answer: C
Q25. To configure instance-level auditing with db2audit, which authority is required?
A. SYSADM
B. SYSCTRL
C. SECADM
D. SYSMAINT
Answer: A
Q26. A database named TEST was created and two buffer pools named BP_GENERAL and BP_AUDITING were created as follows:
The majority of the database tables were created in table space TS1, while one large table was created in table space TS2. A set of triggers thatThe majority of the database tables were created in table space TS1, while one large table was created in table space TS2. A set of triggers that would populate the table in table space TS2 each time changes were made to the database were then defined and the database was put into production.
At first, ad-hoc queries performing random I/O against the table in table space TS2 ran fine, but performance has gotten worse as the table has gotten larger. What should be done to improve query performance?
A. Reduce the size of the BP_AUDITING buffer pool.
B. Increase the size of the BP_AUDITING buffer pool.
C. Change the page size of the BP_AUDITING buffer pool to 16 or 32 K.
D. Replace the BP_AUDITING buffer pool with a block-based buffer pool.
Answer: A
Q27. When defining storage groups for multi-temperature data, storage paths are usually grouped according to their quality of service characteristics. What are three common quality of service characteristics used?
A. Frequency of access; acceptable access time; volatility of the data.
B. Acceptable access time; redundancy of the data; volatility of the data.
C. TIR (table/index data ratio); frequency of access; volatility of the data;
D. Frequency of access; redundancy of the data; acceptable access time;
Answer: A
Q28. A table space creation operation was unsuccessful because DB2 failed to allocate a container in a path. Which diagnostic tool can be used to help resolve the problem?
A. db2dart
B. db2diag
C. db2caem
D. db2fmcu
Answer: B
Q29. What values can be assigned to the HADR_SYNCMODE configuration parameter?
A. SYNC, NEARSYNC, ASYNC, and NOSYNC
B. SYNC, NOSYNC, ASYNC, and SUPERASYNC
C. SYNC, ASYNC, SEMISYNC, and SUPERASYNC
D. SYNC, NEARSYNC, ASYNC, and SUPERASYNC
Answer: D
Q30. What are two services that the cluster caching facility (CF) provides in a DB2 pureScale environment? (Choose two.)
A. Global Lock Management (GLM)
B. Group Transaction Routing (GTR)
C. Automated Member Restart (AMR)
D. Buffer Pool Synchronization (BPS)
E. Shared Communications Area (SGA)
Answer: A,E