100% Correct of C2090-614 pdf exam materials and bootcamp for IBM certification for IT learners, 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 Apr C2090-614 Study Guide Questions:
Q1. Which command(s) should be used to drop database partition 10 from a database named MYDB?
A. STOP DBM DROP DBPARTITIONNUM 10; DROP DBPARTITIONNUM VERIFY;
B. DROP DBPARTITIONNUM VERIFY; STOP DBM DROP DBPARTITIONNUM 10;
C. CONNECT TO mydb; DROP DBPARTITIONNUM 10; CONNECT RESET;
D. CONNECT TO mydb; DROP DBPARTITIONNUM 10; ACTIVATE DB mydb;
Answer: B
Q2. To configure instance-level auditing with db2audit, which authority is required?
A. SYSADM
B. SYSCTRL
C. SECADM
D. SYSMAINT
Answer: A
Q3. The following query is executed frequently against the SALES table: SELECT sales_person, region FROM sales WHERE region = 'Quebec' Which statement will create an index for optimal query performance?
A. CREATE INDEX sales_idx ON sales (region)
B. CREATE INDEX sales_idx ON sales (sales_person)
C. CREATE INDEX sales_idx ON sales (region, sales_person)
D. CREATE INDEX sales_idx ON sales (region) INCLUDE (sales_person)
Answer: C
Avant-garde C2090-614 exam cram:
Q4. Which constraints are used to tell the DB2 Optimizer to consider business rules that are not enforced by the database manager?
A. Check constraints
B. Default constraints
C. Informational constraints
D. Referential integrity constraints
Answer: C
Q5. 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
Q6. What is the default user workload class that is created for each database table?
A. DEFAULT_USER
B. SYSUSERDEFAULTWLM
C. SYSDEFAULTUSERWORKLOAD
D. SYS_DEFAULT_USER_WORKLOAD
Answer: C
Download C2090-614 braindump:
Q7. An auxiliary HADR standby database must use which HADR sync mode?
A. SYNC
B. ASYNC
C. NEARSYNC
D. SUPERASYNC
Answer: D
Q8. In which scenario should a DBA consider creating a multidimensional clustering (MDC) table instead of a regular base table?
A. To improve access performance for tables in an OLTP database.
B. To improve index performance in a data warehouse environment.
C. To improve query performance in a data warehouse environment.
D. To improve insert/delete performance for tables in an OLTP database.
Answer: C
Q9. After starting a series of LOAD operations it appears that one LOAD is failing. What diagnostic tool would you use to determine which LOAD operation is being problematic?
A. db2pd
B. db2dart
C. db2fodc
D. db2ls
Answer: A
Q10. What will occur when a database administrator adds a new automatic storage path to an existing storage group?
A. New table spaces will start consuming storage on the new path.
B. Existing table spaces will not consume storage on the new path.
C. The storage group will be placed in "Rebalance Pending" mode.
D. DB2 will verify that space is available on the storage path specified.
Answer: B