IBM IBM Certified Advanced Database Administrator A2090-544 Questions & Answers

• Question 51:

  Which conditions must be met to implement HADR?

  A. Operating systems on primary and standby servers must be the same; DB2 versions need not be the same; and the databases must have the same bit-size (32 or 64 bit).

  B. Operating systems on primary and standby servers need not be the same; DB2 versions must be the same; and the databases need not have the same bit-size (32 or 64 bit).

  C. Operating systems on primary and standby servers must be the same; DB2 versions must be the same; and the databases need not have the same bit-size (32 or 64 bit).

  D. Operating systems on primary and standby servers must be the same; DB2 versions must be the same; and the databases must have the same bit-size (32 or 64 bit).

  Correct Answer: D

• Question 52:

  A DBA would like to examine repartitioning options for a partitioned database named PRODDB. Which tool can be used to provide recommendations on re-partitioning?

  A. Configuration Advisor

  B. Partition Assistant

  C. Design Advisor

  D. Workload Manager

  Correct Answer: C

• Question 53:

  How can a DBA validate that an existing backup was compressed?

  A. Check the output from the command LIST HISTORY BACKUP ALL FOR the database.

  B. Check the value of the COMPRESS_BACKUP database configuration setting.

  C. Check the value of the DB2_COMPRESS_BACKUP registry variable.

  D. Check the header information of the backup file using db2ckbkp.

  Correct Answer: D

• Question 54:

  If LOGSECOND=-1 then which of the following statements is true?

  A. You still use LOGPRIMARY and LOGFILSIZ configuration parameters to specify how many log files the database manager should keep in the active log path.

  B. You must configure the OVERFLOWLOGPATH configuration parameter if your active log path is not on a raw device.

  C. The database will reserve active log space for transactions that may need to roll back and write log records.

  D. An infinite number of overflow log files will be used with archival logging.

  Correct Answer: A

• Question 55:

  When the DBA chooses the dimensions for a multi-dimensional clustering (MDC) table, which two characteristics should be considered? (Choose two.)

  A. the query transaction rate

  B. numeric data versus character data

  C. extent size

  D. the combined cardinality of the candidate columns

  E. prefetch size

  Correct Answer: CD

• Question 56:

  Which factor should influence your selection of distribution key(s)?

  A. The distribution key(s) should include the most frequently accessed XML column(s).

  B. The distribution key(s) should include the longest column(s).

  C. The distribution key(s) should include column(s) with the smallest number of distinct values.

  D. The distribution key(s) should include the most frequently joined column(s).

  Correct Answer: D

• Question 57:

  The DBA needs to create a table with key columns YEARMONTH and YEAR. This table needs to be partitioned by column YEARMONTH with three months per data partition. Additionally, data needs to be organized by column YEAR, so that all rows within any three month date range are clustered together based on 12 months of data. Which CREATE TABLE statement will accomplish this objective?

  A. CREATE TABLE tab1(yearmonth INT,year CHAR(2))PARTITION BY RANGE (year) (STARTING 201001 ENDING 201012 EVERY 12)ORGANIZE BY DIMENSIONS (yearmonth))

  B. CREATE TABLE tab1(yearmonth INT,year CHAR(2))PARTITION BY RANGE (year) (STARTING 201001 ENDING 201012 EVERY 3)ORGANIZE BY DIMENSIONS (yearmonth))

  C. CREATE TABLE tab1(yearmonth INT,year CHAR(2))PARTITION BY RANGE (yearmonth) (STARTING 201001 ENDING 201012 EVERY 12)ORGANIZE BY DIMENSIONS (year))

  D. CREATE TABLE tab1(yearmonth INT,year CHAR(2))PARTITION BY RANGE (yearmonth) (STARTING 201001 ENDING 201012 EVERY 3)ORGANIZE BY DIMENSIONS (year))

  Correct Answer: D

• Question 58:

  An active partitioned instance named DB2INST1 uses the following db2nodes.cfg file: 1 server1 0 2 server1 1 3 server1 2 4 server1 3 The following command is issued to add a new database partition: db2start DBPARTITIONNUM 5 ADD DBPARTITIONNUM HOSTNAME server1 PORT 4 Upon successful completion of the db2start command, which statement is true regarding the status of the instance DB2INST1?

  A. Partitions 1, 2, 3, 4, and 5 are active and available.

  B. Partitions 1, 2, 3, and 4 are active, but partition 5 is not.

  C. All partitions are active but partition 5 is not available until a temporary table space is defined.

  D. DB2 responds to the configuration change by stopping all partitions.

  Correct Answer: B

• Question 59:

  What are the steps required to remove July 2005 data from a partitioned table and replace with it with July 2010 data?

  A. 1) Detach partition containing July 2005 data2) Load July 2010 data into a new table3) Attach the new table as a new partition in the existing partitioned table4) Check constraint integrity for the partitioned table

  B. 1) Detach partition containing July 2005 data2) Load July 2010 data into a new table3) Attach the new table as a new partition in the existing partitioned table4) Rebind the partitioned table

  C. 1) Detach partition containing July 2005 data2) Load July 2010 data into a new table3) Attach the new table as a new partition in the existing partitioned table4) Update statistics on the partitioned table

  D. 1) Detach partition containing July 2005 data2) Load July 2010 data into a new table3) Attach the new table as a new partition in the existing partitioned table4) Reorg the partitioned table

  Correct Answer: A

• Question 60:

  A partitioned instance named DB2INST1 uses the following db2nodes.cfg file:

  If the CREATE DATABASE command is executed on server C, which partition will be the catalog partition?

  A. 0

  B. 1

  C. 4

  D. 6

  Correct Answer: C