Ucertify offers free demo for C2090-614 exam. "DB2 10.1 Advanced DBA for Linux UNIX and Windows (C2090-614)", also known as C2090-614 exam, is a IBM Certification. This set of posts, Passing the IBM C2090-614 exam, will help you answer those questions. The C2090-614 Questions & Answers covers all the knowledge points of the real exam. 100% real IBM C2090-614 exams and revised by experts!
♥♥ 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. Which Workload Manager (WLM) objects can the COLLECT ACTIVITY DATA clause be used with?
A. Data class, work class, and a limit
B. Data class, action class, and a threshold
C. Service subclass, action class, and a limit
D. Service subclass, work class, and a threshold
Answer: D
Q2. Where is the HADR_TARGET_LIST configuration parameter set?
A. On the primary database only.
B. On all participating databases.
C. On the tertiary standby databases.
D. On the auxiliary standby databases only.
Answer: B
Q3. Which statement about value compression is correct?
A. To use value compression, you must have a license for the DB2 Storage Optimization Feature.
B. Value compression uses a page-level dictionary-based compression algorithm to compress data based on repetition of values found in a single column.
C. Value compression involves removing duplicate entries for a value, only storing one copy, and keeping track of the location of any references to the stored copy.
D. When value compression is used, the byte count of compressed NULLs, zeros, and blanks might be larger than that of the uncompressed version of the same values.
Answer: C
Q4. 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
Q5. Which statement about DB2 Merge Backup is FALSE?
A. It can be used to merge offline backups to build full offline table space backups.
B. It can be used to merge SNAPSHOT and TSM tape backup images to create a full database backup image.
C. It can be used merge multiple offline database backups to build a cumulative single offline database backup.
D. It can be used to merge backups on a machine that is different from the machine where the backup has been created in stand-alone mode.
Answer: B
Q6. Given the following database design:
A Explain plan shows that a broadcast join is being used by a query that joins the DATE_DIM dimension table and the SALES fact table. Which action should be performed to improve query performance?
A. Create a replicated summary table for the SALES table using the table space TS_REPL.
B. Create a replicated summary table for the DATE_DIM table using the table space TS_REPL.
C. Create an index on both the DATE_DIM and the SALES table for the column that is used in the collocated join.
D. Create a replicated summary table for the SALES table using the table space TS_DIM and create an index on the DATE_DIM table.
Answer: B
Q7. What contributes to the efficient use of block-based buffer pools?
A. The application does not use sequential prefetching.
B. The application performs a lot of random I/O operations.
C. The table space extent size is equal to the block size specified for the buffer pool.
D. The table space prefetch size is equal to the block size specified for the buffer pool.
Answer: C
Q8. Which statement about the initiation of parallel I/O is correct?
A. For list prefetching, each list of data pages is divided into smaller lists according to extent boundaries and assigned to different I/O servers.
B. For read-ahead prefetching, each list of data pages is divided into smaller lists according to extent boundaries and assigned to different I/O servers.
C. For sequential prefetching, parallel I/O is initiated when the prefetch size is a multiple of the extent size for a table space. Each prefetch request is divided into smaller requests and assigned to different I/O servers.
D. For sequential prefetching, parallel I/O is initiated when the extent size is a multiple of the prefetch size for a table space. Each prefetch request is divided into smaller requests and assigned to different I/O servers.
Answer: C
Q9. A storage group named MED_SG was created as follows: CREATE STOGROUP med_sg ON ?db2fs1? ?db2fs2? '/db2fs3' Then, a table space named TS1 was created in the storage group and two tables (TAB_A and TAB_B) were created in the TS1 table space. Four months later, a DBA discovered that 90% of the space that had been allocated to the MED_SG storage group had been consumed. So, more space was added to the storage group by executing the following command: ALTER STOGROUP med_sg ADD ?db2fs4? ALTER STOGROUP med_sg ADD ?db2fs4 Shortly afterwards, queries against tables in the TS1 table space began to run slower. Which statement should be executed to correct the performance problem?
A. ALTER TABLESPACE ts1 REBALANCE
B. ALTER STOGROUP med_sg ADD ?db2fs5?ALTER STOGROUP med_sg ADD ?db2fs5
C. ALTER STOGROUP med_sg DROP '/db2fs4'
D. ALTER TABLESPACE ts1 ADD '/db2fs4' REBALANCE
Answer: A
Q10. Which statement about partitioned indexes is FALSE?
A. Both system- and user-generated indexes can be partitioned.
B. Each index partition contains references only to data in its corresponding data partition.
C. A partitioned index is made up of a set of index partitions, each of which contains the index entries for a single data partition
D. When attaching new partitions, the SET INTEGRITY statement must be run before data in the newly attached partition will be reflected in the corresponding partition index.
Answer: D