Given the following database design:

A Explain plan shows that a broadcast join is being used by a query that joins the DATE_DIM dimension table and the SALES fact table. Which action should be performed to improve query performance?

A. Create a replicated summary table for the SALES table using the table space TS_REPL.

B. Create a replicated summary table for the DATE_DIM table using the table space TS_REPL.

C. Create an index on both the DATE_DIM and the SALES table for the column that is used in the collocated join.

D. Create a replicated summary table for the SALES table using the table space TS_DIM and create an index on the DATE_DIM table.

Which procedure is used to Explain an SQL statement using information obtained from the package cache or the package cache event monitor?

A. EXPLAIN_FROM_DATA

B. EXPLAIN_FROM_ACTIVITY

C. EXPLAIN_FROM_SECTION

D. EXPLAIN_FROM_CATALOG

What is the recommended method for removing old backup images and log files for a DB2 10.1 database?

A. Manually delete old backups and logs.

B. Utilize the PRUNE LOGFILE PRIOR TO command to remove old backups and logs.

C. Utilize the PRUNE HISTORY AND DELETE command to remove old backups and logs.

D. Set the DB2PRUNE_ACTION_LOG configuration parameter to a desired date before generating a new backup.

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

A. AIX

B. Linux

C. HP-UX

D. Solaris

E. Windows

What is the preferred method for reclaiming unused storage in a DMS table space?

A. Perform an ALTER TABLESPACE...REDUCE operation.

B. Perform a REORG on each table within the table space, then perform an ALTER TABLESPACE...REDUCE operation.

C. Perform an ALTER TABLESPACE...LOWER HIGH WATER MARK operation, and then an ALTER TABLESPACE...REDUCE operation.

D. Perform a REORG on each table within the table space, then perform an ALTER TABLESPACE...LOWER HIGH WATER MARK operation.

What type of file system is used to store data and logs in a DB2 pureScale environment?

A. Network File System (NFS)

B. General Parallel File System (GPFS)

C. Common Internet File System (CIFS)

D. Enhanced Journaled File System (JFS2 or EXT4)

When will the existing data for a new partition be visible to applications querying a range-partitioned table?

A. After the ALTER TABLE ... ADD statement is executed.

B. After the ALTER TABLE ... ATTACH statement is executed.

C. After the ALTER TABLE ... ADD and SET INTEGRITY statements are executed.

D. After the ALTER TABLE ... ATTACH and SET INTEGRITY statements are executed.

If the following commands complete successfully for a single partition database: CREATE DATABASE mydb;

CREATE BUFFERPOOL mybp; Which statement is true?

A. Self tuning is enabled for the MYBP buffer pool.

B. The initial size for the MYBP buffer pool is zero pages.

C. The database has to be restarted before the MYBP buffer pool will become active.

D. The page size for the MYBP buffer pool can be changed using the ALTER BUFFERPOOL statement.

Which type of storage is utilized in the implementation of an effective and flexible multi- temperature database?

A. System managed storage

B. Automatic storage utilizing storage groups

C. System managed storage utilizing storage groups

D. Database managed storage with file system caching

Which configuration parameter is used to designate a storage area for archived log files that are retrieved for recovery purposes?

A. logarchopt1

B. failarchpath

C. mirrorlogpath

D. overflowlogpath