Try IBM : 000-614 practice torrent pass for sure

IBM 000-614 Exam Overview:

IBM 000-614 Exam Syllabus Topics:

IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows Sample Questions:

1. 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) 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) 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.

2. 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 ALL DBPARTITIONNUMS EXCEPT CATPARTITION TO /mnt/backup
B) BACKUP DATABASE sales ON ALL DBPARTITIONNUMS EXCEPT DBPARTITIONNUM (1) TO /mnt/backup
C) BACKUP DATABASE sales ON ALL DBPARTITIONNUMS TO /mnt/backup
D) BACKUP DATABASE sales ON DBPARTITIONNUM (1) TO /mnt/backup

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

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

4. 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 (sales_person)
B) CREATE INDEX sales_idx ON sales (region)
C) CREATE INDEX sales_idx ON sales (region, sales_person)
D) CREATE INDEX sales_idx ON sales (region) INCLUDE (sales_person)

5. A storage group named HOT_SG was created as follows:

What does the DATA TAG 1 clause do?

A) It tells the DB2 Optimizer that database objects stored in the HOT_SG storage group are to be given preference over other objects when data access plans are generated.
B) It indicates that the multiple storage paths referenced in the HOT_SG storage group definition exist in one physical location.
C) It indicates that the value 1 is to be assigned to data stored in the HOT_SG storage group, which Workload Manager (WLM) can then use to determine the processing priority to assign to database activities that interact with this data.
D) It assigns a unique identifier to the instance of the HOT_SG storage group being defined; this identifier can then be used when moving table spaces to and from the storage group, when dropping the storage group, or when commenting on the storage group.

Solutions: