Best Quality of C2090-614 download materials and training tools for IBM certification for IT candidates, 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:
Q41. Which monitoring tool can be used to obtain stripe set information for database managed storage table spaces?
A. The MON_GET_CONTAINER table function.
B. The SNAP_GET_TBSP_PART table function.
C. The SNAPTBSP_RANGE administrative view.
D. The TS_GET_CONTAINER administrative view.
Answer: A
Q42. Which would not significantly benefit from having the RUNSTATS command run on it?
A. Tables that have had little change.
B. Tables where a new index has been created.
C. Tables that have been reorganized (using REORG).
D. Tables that have been populated with a LOAD operation.
Answer: A
Q43. A table space creation operation was unsuccessful because DB2 failed to allocate a container in a path. Which diagnostic tool can be used to help resolve the problem?
A. db2dart
B. db2diag
C. db2caem
D. db2fmcu
Answer: B
Up to the minute C2090-614 test question:
Q44. What must be done to convert an existing table into an Insert-Time-Clustered (ITC) table?
A. Call the ADMIN_MOVE_TABLE procedure.
B. Call the ADMIN_REVALIDATE_DB_OBJECTS procedure.
C. Issue a REORG TABLE statement with the ORGANIZE BY INSERT TIME option.
D. Issue an ALTER TABLE statement with the ORGANIZE BY INSERT TIME option.
Answer: A
Q45. Which statement about block indexes is correct?
A. Because of their large size, block indexes are extremely efficient.
B. Block indexes improve performance when data is not clustered on sequential pages.
C. Prefetching of data pages relies on sequential detection when block indexes are used.
D. The records for each block are retrieved using a mini-relational scan of saved data pages.
Answer: C
Q46. For a multi-partitioned database, what is the default behavior of the BACKUP DATABASE command?
A. It will backup just the catalog partition.
B. It will backup all partitions simultaneously.
C. It will backup just the partition that the command is executed from.
D. It will backup just the partitions that reside on the host that the command is executed from.
Answer: C
Exact C2090-614 keys:
Q47. What event category is used with the db2audit command to capture SQL data, such as host variable and parameter marker values, that are associated with an SQL statement?
A. AUDIT
B. VALIDATE
C. EXECUTE
D. CONTEXT
Answer: C
Q48. Which configuration parameter setting(s) are needed to force authentication to happen at the data source in a federated database environment?
A. FEDERATED set to YES
B. FEDERATED set to YES AUTHENTICATION set to SERVER or SERVER_ENCRYPT
C. FEDERATED set to YES FED_NOAUTH set to YES
D. FEDERATED set to YES FED_NOAUTH set to YES AUTHENTICATION set to SERVER or SERVER_ENCRYPT
Answer: D
Q49. 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
Q50. What are two supported methods for providing a low latency, high speed interconnect between DB2 members and the cluster caching facility (CF) in a DB2 pureScale environment? (Choose two.)
A. InfiniBand with RDMA (IB)
B. SCSI RDMA Protocol (SRP)
C. iSCSI Extensions for RDMA (iSER)
D. RDMA over Converged Ethernet (RoCE)
E. Internet Wide Area RDMA Protocol (iWARP)
Answer: A,D