Download of C2090-614 actual test materials and resource for IBM certification for examinee, Real Success Guaranteed with Updated C2090-614 pdf dumps vce Materials. 100% PASS DB2 10.1 Advanced DBA for Linux UNIX and Windows (C2090-614) exam Today!
2021 May C2090-614 Study Guide Questions:
Q51. What statement regarding Asynchronous index cleanup (AIC) is correct?
A. AIC removes all invalid index entries that refer to the attached partitions.
B. AIC is initiated if a range-partitioned table contains one or more nonpartitioned indexes.
C. AIC activates a newly attached partition after the index entries have been synchronized.
D. AIC will not be initiated if a range-partitioned table has dependent materialized query tables (MQTs).
Answer: B
Q52. Which monitoring tool can be used to find out how many data pages have been read from the table space containers for regular, large, and temporary table spaces?
A. The MON_DB_SUMMARY administrative view.
B. The MON_BP_UTILIZATION administrative view.
C. The MON_GET_ACTIVITY_DETAILS table function.
D. The MON_GET_EXTENT_MOVEMENT_STATUS table function.
Answer: B
Q53. 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
Rebirth C2090-614 practice test:
Q54. What two types of information can be obtained with the MON_GET_TABLESPACE monitor table function? (Choose two.)
A. Table space available space
B. Table space read and write activity
C. Table space container assignments
D. Table level activity within a table space
E. Table space backup and recovery information
Answer: A,B
Q55. 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
Q56. 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
High value C2090-614 bootcamp:
Q57. 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
Q58. 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
Q59. 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
Q60. A database administrator created all of the necessary federated objects for an SQL Server data source in a federated system. Which steps must be performed if the data types of several columns in the SQL Server data source are changed?
A. Drop the current data type mapping. Create the new data type mapping.
B. Drop the nickname to the table. Create the new data type mapping. Recreate the nickname to the table.
C. Drop the current data type mapping. Create the new data type mapping. Drop the nickname to the table. Recreate the nickname to the table.
D. Drop the current user mapping. Drop the current data type mapping. Create the new user mapping. Create the new data type mapping. Recreate the nickname to the table.
Answer: B