Free IBM 000-614 Exam Dumps Questions & Answers

In which situation would you NOT use a redirected restore?

• A.To restore a backup image from one operating system to another.
• B.To restore a backup image to a target machine that is different from the source machine.
• C.To move table space containers onto different physical devices.
• D.To redefine the paths of a defined storage group.

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 KEY SEQUENCE
• B.ORGANIZE BY INSERT TIME
• C.ORGANIZE BY DIMENSIONS
• D.ORGANIZE BY TIME PERIOD

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

On which two operating systems can DB2 pureScale run? (Choose two.)

• A.AIX
• B.Solaris
• C.HP-UX
• D.Windows
• E.Linux

To configure instance-level auditing with db2audit, which authority is required?

• A.SYSADM
• B.SYSCTRL
• C.SYSMAINT
• D.SECADM