Actual of C2090-614 actual test materials and pack for IBM certification for consumer, 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:
Q61. 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
Q62. 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
Q63. Which type of storage is utilized in the implementation of an effective and flexible multi-temperature database?
A. System managed storage
B. Automatic storage utilizing storage groups
C. System managed storage utilizing storage groups
D. Database managed storage with file system caching
Answer: B
Renovate C2090-614 braindumps:
Q64. You need to restore a table space that was backed up earlier, but before you begin a restore operation you want to determine whether any tables in the table space were populated with a LOAD ... NONRECOVERABLE operation. What can be used to provide this information?
A. The INSPECT utility
B. The db2pd command
C. The db2dart command
D. The database recovery history file
Answer: D
Q65. A query against the system catalog revealed that data for a table named SALES in a partitioned database is distributed as follows:
What can be done to improve the performance of a query that joins SALES and DATE_DIM tables (where SALES is a fact table and DATE_DIM is a dimension table) using the DATE_ID column?
A. Reload table SALES and use only one partition with a collocated join to the DATE_DIM table using the primary key DATE_ID.
B. Reload table DATE_DIM and use only one partition with a collocated join to the SALES table using the primary key DATE_ID.
C. Create a replicated table REPL_SALES from the SALES table, refresh REPL_SALES table, create index on DATE_ID column in theREPL_SALES table, and collect statistics on REPL_SALES table.
D. Create a replicated table REPL_DATE_DIM from the DATE_DIM table, refresh REPL_DATE_DIM table, create index on DATE_ID column in theREPL_DATE_DIM table, and collect statistics on REPL_DATE_DIM table.
Answer: D
Q66. Prior to migrating to DB2 10.1, a DBA executed the following command on a daily basis: db2_all "<<-1< db2 BACKUP DATABASE sales TO /mnt/backup" Which command can now be used to perform the same backup operation?
A. BACKUP DATABASE sales ON DBPARTITIONNUM (1) TO /mnt/backup
B. BACKUP DATABASE sales ON ALL DBPARTITIONNUMS TO /mnt/backup
C. BACKUP DATABASE sales ON ALL DBPARTITIONNUMS EXCEPT CATPARTITION TO /mnt/backup
D. BACKUP DATABASE sales ON ALL DBPARTITIONNUMS EXCEPT DBPARTITIONNUM (1) TO /mnt/backup
Answer: D
Simulation C2090-614 item pool:
Q67. What is a benefit of multi-temperature data storage?
A. It helps reduce redundant I/O.
B. It helps improve data compression ratios.
C. It helps reduce storage costs for infrequently accessed data.
D. It helps identify data access patterns to aid in storage planning.
Answer: C
Q68. The following statement was used to create a table space named USER_TMP in a non-partitioned database: CREATE USER TEMPORARY TABLESPACE user_tmp MANAGED BY SYSTEM USING (?mnt/fsystem4? ?mnt/fsystem5? Which operation can be performed on the USER_TMP table space with an ALTER TABLESPACE statement?
A. New storage containers can be added to it.
B. A different buffer pool can be associated with it.
C. A hard limit can be placed on the size to which its storage containers can grow.
D. Its high water mark can be lowered and its size can be reduced to the high water mark.
Answer: B
Q69. Which tool provides the simplest method for monitoring buffer pool hit ratios?
A. The BP_HITRATIO administrative view.
B. The BP_WRITE_IO administrative view.
C. The MON_GET_BUFFERPOOL table function.
D. The MON_GET_PAGE_ACCESS_INFO table function.
Answer: A
Q70. 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