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

Question 1

Which data organization schemes are supported?

A. PARTITION BY RANGE and ORGANIZE BY B. PARTITION BY HASH and ORGANIZE BY RANGE C. PARTITION BY RANGE and ORGANIZE BY HASH D. PARTITION BY HASH and ORGANIZE BY

Discussion 0

Correct Answer: A Vote an answer

Question 2

What is the proper set of steps to execute a redirected restore and change the container paths for a database not using automatic storage?

A. Issue a RESTORE DATABASE command with the REDIRECT option;
issue a SET TABLESPACE CONTAINERS command;
issue a RESTORE DATABASE command with the CONTINUE option; B. Issue a RESTORE DATABASE command with the ROLLFORWARD option;
issue a SET TABLESPACE CONTAINERS command;
issue a RESTORE DATABASE command with the CONTINUE option; C. Issue a RESTORE DATABASE command with the REDIRECT option;
issue a RESTORE DATABASE command with the CONTINUE option; D. Issue a RESTORE DATABASE command with the ROLLFORWARD option;
issue a RESTORE DATABASE command with the CONTINUE option;

Discussion 0

Correct Answer: A Vote an answer

Question 3

Given an HADR pair configured with HADR_PEER_WINDOW set to 300 seconds. If the standby server looses communication with the primary at 11:02:03 am, when can the following command be run so that the standby server will successfully be promoted to be a primary server?
TAKEOVER HADR ON DB mydb BY FORCE PEER WINDOW ONLY

A. Any time after 11:07:04 am B. Any time after 11:07:03 am C. Any time after 11:02:03 am D. Any time before 11:07:03 am

Discussion 0

Correct Answer: D Vote an answer

Question 4

Given INTRA_PARALLEL is OFF, average row length is 900 bytes, and temporary table cardinality is 1000, which setting would prevent a SORTHEAP overflow when the temporary table is sorted?

A. SORTHEAP AUTOMATIC, SHEAPTHRES 0 B. SORTHEAPTHRES 10000K, SORTHEAP 250K C. SORTHEAP AUTOMATIC, SHEAPTHRES 10000K D. SORTHEAPTHRES 10000K

Discussion 0

Correct Answer: A Vote an answer

Question 5

Which command CANNOT be used to explicitly build a compression dictionary for a table?

A. LOAD B. IMPORT C. INSPECT D. REORG

Discussion 0

Correct Answer: B Vote an answer

Question 6

In which two environments would intra-partition parallelism be used? (Choose two.)

A. Multiple database partitions, single processor core B. Multiple database partitions, multiple processor cores C. Single database partition, single processor core D. Single database partition, multiple processor cores

Discussion 0

Correct Answer: B,D Vote an answer

Question 7

Which database manager configuration parameter is used to set an instance-wide soft limit on the total amount of memory that can be consumed by private sorts, within that instance, at any given time?

A. SORTHEAP B. SHEAPTHRES C. SORTHEAP_SHR D. SHEAPTHRES_SHR

Discussion 0

Correct Answer: B Vote an answer

Question 8

Which statement about compression and temporary tables is NOT correct?

A. Compression is only applied to created temporary tables that were defined with the CREATE TEMPORARY TABLE ?COMPRESS YES statement. B. The explain facility and the db2pd utility can be used to determine whether a temporary table has been compressed. C. The minimum size that a table must be before compression is used is larger for temporary tables than for regular tables. D. When executing queries that require temporary tables, DB2 considers the storage savings and the impact to query performance to determine whether compression is worthwhile.

Discussion 0

Correct Answer: A Vote an answer

Question 9

Which command CANNOT be used to create the compression dictionary for a table?

A. LOAD B. RUNSTATS C. IMPORT D. INSPECT

Discussion 0

Correct Answer: B Vote an answer