IBM Assessment: DB2 10.1 Advanced DBA for LUW - A2090-614 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

What will occur when a database administrator adds a new automatic storage path to an existing storage group?

A. Existing table spaces will not consume storage on the new path. B. DB2 will verify that space is available on the storage path specified. C. The storage group will be placed in "Rebalance Pending" mode. D. New table spaces will start consuming storage on the new path.

Discussion 0

Correct Answer: A Vote an answer

Question 2

What can be done to prevent applications from failing when DB2 cannot create a new log file?

A. Set LOGSECOND to -1 B. Set BLK_LOG_DSK_FUL to YES C. Set LOGBUFSZ to -1 D. Set MAX_LOG to 0

Discussion 0

Correct Answer: B Vote an answer

Question 3

Which diagnostic tool can be used to show high-watermark consumptions of Fast Communication Manager (FCM) buffers and channels?

A. db2dart B. db2pd C. inspect D. db2mtrk

Discussion 0

Correct Answer: B Vote an answer

Question 4

Which monitoring tool can be used to obtain stripe set information for database managed storage table spaces?

A. The SNAP_GET_TBSP_PART table function. B. The TS_GET_CONTAINER administrative view. C. The MON_GET_CONTAINER table function. D. The SNAPTBSP_RANGE administrative view.

Discussion 0

Correct Answer: C Vote an answer

Question 5

In which scenario should a DBA consider creating a multidimensional clustering (MDC) table instead of a regular base table?

A. To improve query performance in a data warehouse environment. B. To improve index performance in a data warehouse environment. C. To improve insert/delete performance for tables in an OLTP database. D. To improve access performance for tables in an OLTP database.

Discussion 0

Correct Answer: A Vote an answer

Question 6

Which statement about the initiation of parallel I/O is correct?

A. 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. B. 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. C. 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. D. For list prefetching, each list of data pages is divided into smaller lists according to extent boundaries and assigned to different I/O servers.

Discussion 0

Correct Answer: A Vote an answer

Question 7

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. 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. B. 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. C. Reload table DATE_DIM and use only one partition with a collocated join to the SALES table using the primary key DATE_ID. D. Reload table SALES and use only one partition with a collocated join to the DATE_DIM table using the primary key DATE_ID.

Discussion 0

Correct Answer: A Vote an answer

Question 8

The following query is executed frequently against the SALES table: SELECT sales_id, sales_date, sales_person FROM sales; If data in the SALES_ID column is unique, which statement will create an index for optimal query performance and ensure uniqueness of the SALES_ID column?

A. CREATE INDEX sales_idx ON sales (sales_id, sales_date, sales_person) B. CREATE INDEX sales_idx ON sales (sales_id) INCLUDE (sales_date, sales_person) C. CREATE UNIQUE INDEX sales_idx ON sales (sales_id) INCLUDE (sales_date, sales_person) D. CREATE UNIQUE INDEX sales_idx ON sales (sales_id, sales_date, sales_person)

Discussion 0

Correct Answer: C Vote an answer

Question 9

Which tool provides the simplest method for monitoring buffer pool hit ratios?

A. The MON_GET_BUFFERPOOL table function. B. The MON_GET_PAGE_ACCESS_INFO table function. C. The BP_HITRATIO administrative view. D. The BP_WRITE_IO administrative view.

Discussion 0

Correct Answer: C Vote an answer

Question 10

What is the default user workload class that is created for each database table?

A. SYSUSERDEFAULTWLM B. DEFAULT_USER C. SYS_DEFAULT_USER_WORKLOAD D. SYSDEFAULTUSERWORKLOAD

Discussion 0

Correct Answer: D Vote an answer