It is impossible to pass IBM C2090-614 exam without any help in the short term. Come to Pass4sure soon and find the most advanced, correct and guaranteed IBM C2090-614 practice questions. You will get a surprising result by our Update DB2 10.1 Advanced DBA for Linux UNIX and Windows (C2090-614) practice guides.
♥♥ 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
Q1. 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
Q2. Which configuration parameter is used to designate a storage area for archived log files that are retrieved for recovery purposes?
A. logarchopt1
B. failarchpath
C. mirrorlogpath
D. overflowlogpath
Answer: D
Q3. 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
Q4. Which statement about Range Clustered Tables (RCT) is correct?
A. Storage space is not pre-allocated for an RCT.
B. The ALTER TABLE statement can be used to change the physical structure of an RCT.
C. When defining a range of key values for an RCT, a minimum value is optional.
D. The minimum value of a key column for an RCT cannot be a negative value.
Answer: C
Q5. Which diagnostic tool can be used to collect metrics on individual SQL statement executions?
A. db2dart
B. A snapshot monitor
C. A statement event monitor
D. The MON_GET_UNIT_OF_WORK_DETAILS table function
Answer: C
Q6. What can be done to prevent applications from failing when DB2 cannot create a new log file?
A. Set MAX_LOG to 0
B. Set LOGBUFSZ to -1
C. Set LOGSECOND to -1
D. Set BLK_LOG_DSK_FUL to YES
Answer: D
Q7. With HADR, IBM Tivoli System Automation for Multiplatforms (SA MP) automated failover can be used with which database(s)?
A. The primary database only.
B. The auxiliary standby database only.
C. The principal standby database only.
D. The primary, auxiliary standby, and principal standby database.
Answer: C
Q8. After starting a series of LOAD operations it appears that one LOAD is failing. What diagnostic tool would you use to determine which LOAD operation is being problematic?
A. db2pd
B. db2dart
C. db2fodc
D. db2ls
Answer: A
Q9. If the following commands complete successfully for a single partition database: CREATE DATABASE mydb; CREATE BUFFERPOOL mybp; Which statement is true?
A. Self tuning is enabled for the MYBP buffer pool.
B. The initial size for the MYBP buffer pool is zero pages.
C. The database has to be restarted before the MYBP buffer pool will become active.
D. The page size for the MYBP buffer pool can be changed using the ALTER BUFFERPOOL statement.
Answer: A
Q10. Which is a poor choice for a clustering dimension of a multidimensional clustering (MDC) table?
A. Columns with low cardinalities
B. Columns with high cardinalities
C. Columns involved in roll-in or roll-out of data
D. Columns involved in equality or range predicate queries
Answer: B