Want to know Pass4sure C2090-614 Exam practice test features? Want to lear more about IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows (C2090-614) certification experience? Study Vivid IBM C2090-614 answers to Improved C2090-614 questions at Pass4sure. Gat a success with an absolute guarantee to pass IBM C2090-614 (DB2 10.1 Advanced DBA for Linux UNIX and Windows (C2090-614)) test on your first attempt.
♥♥ 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
Q41. When will the existing data for a new partition be visible to applications querying a range-partitioned table?
A. After the ALTER TABLE ... ADD statement is executed.
B. After the ALTER TABLE ... ATTACH statement is executed.
C. After the ALTER TABLE ... ADD and SET INTEGRITY statements are executed.
D. After the ALTER TABLE ... ATTACH and SET INTEGRITY statements are executed.
Answer: D
Q42. 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
Q43. 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
Q44. A DBA wants to create a table named SALES that has the following characteristics: ?effective data clustering and management of space utilization ?rows in the table should be clustered based on when they are added to the table Which clause must be used with the CREATE TABLE statement to define this table?
A. ORGANIZE BY DIMENSIONS
B. ORGANIZE BY INSERT TIME
C. ORGANIZE BY TIME PERIOD
D. ORGANIZE BY KEY SEQUENCE
Answer: B
Q45. A storage group named HOT_SG was created as follows:
What does the DATA TAG 1 clause do?
A. It indicates that the multiple storage paths referenced in the HOT_SG storage group definition exist in one physical location.
B. It tells the DB2 Optimizer that database objects stored in the HOT_SG storage group are to be given preference over other objects when data access plans are generated.
C. It indicates that the value 1 is to be assigned to data stored in the HOT_SG storage group, which Workload Manager (WLM) can then use to determine the processing priority to assign to database activities that interact with this data.
D. It assigns a unique identifier to the instance of the HOT_SG storage group being defined; this identifier can then be used when moving table spaces to and from the storage group, when dropping the storage group, or when commenting on the storage group.
Answer: C
Q46. 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
Q47. A DBA wants to create a table named SALES that has the following characteristics:
-Data for the first half of the year will reside in table space TBSP1; the index for this data will reside in table space TBSP21. -Data for the second half of the year will reside in table space TBSP2; the index for this data will reside in table space TBSP22.
Which clause must be used with the CREATE TABLE statement to define this table?
A. DISTRIBUTE BY HASH
B. PARTITION BY RANGE
C. ORGANIZE BY DIMENSIONS
D. ORGANIZE BY KEY SEQUENCE
Answer: B
Q48. What is the FAILARCHPATH database configuration parameter used for?
A. To specify a path that DB2 will use to look for archive log files that are needed for a rollforward recovery operation.
B. To specify a path to which DB2 will attempt to store a copy of archive log files to protect against accidental deletion.
C. To specify a path to which DB2 will attempt to store a copy of both active and archive log files to protect against disk failure and power outages.
D. To specify a path to which DB2 will attempt to store archive log files if they cannot be written to the primary or secondary archive destination because of a media problem.
Answer: D
Q49. 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
Q50. 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