A2090-544 Online Practice Questions and Answers

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

Which command will back up a database named SAMPLE to a TSM server using two concurrent TSM client sessions?

A. BACKUP DATABASE sample USE TSM OPEN 2 SESSIONS WITH 4 BUFFERS

B. BACKUP DATABASE sample USE TSM OPEN 4 SESSIONS WITH 2 BUFFERS

C. BACKUP DATABASE sample USE TSM OPEN 2 SERVERS WITH 4 BUFFERS

D. BACKUP DATABASE sample USE TSM OPEN 4 SERVERS WITH 2 BUFFERS

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

A. IMPORT

B. INSPECT

C. LOAD

D. RUNSTATS

You have a database with eight partitions on a single server. Immediately after executing the following

command:

CREATE BUFFERPOOL mybp DEFERRED SIZE 3000

How much memory is consumed by buffer pool MYBP on the server?

A. 0 pages

B. 3000 pages

C. 24000 pages

D. 192000 pages

Given a database created as follows:

If each table (T1 and T2) has 50,000 rows, which of the following commands will ensure that the temporary table created by the select statement will fit entirely in the buffer pool, assuming that there is a primary key/ foreign key relationship between column C1 in table T1, and column C1 in table T2?

A. CREATE BUFFERPOOL bp1 SIZE 20000 PAGESIZE 4k;ALTER TABLESPACE tempspace1 BUFFERPOOL bp1;

B. CREATE BUFFERPOOL bp1 size 10000 PAGESIZE 8k;

C. CREATE BUFFERPOOL bp1 size 5000 PAGESIZE 16k;ALTER TABLESPACE tempspace1 BUFFERPOOL bp1;

D. CREATE BUFFERPOOL bp1 size 25000 PAGESIZE 32k;

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

In order for HADR to start, which statement is true when setting the HADR_TIMEOUT database configuration value?

A. The HADR_TIMEOUT value must be identical on both the primary and the standby server.

B. Changes to the HADR_TIMEOUT value will take effect immediately.

C. If the HADR_TIMEOUT value is set to -1, connection timeouts will not occur.

D. If the HADR_TIMEOUT value is different between the two servers, the lowest value is used.

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:02:03 am

B. Any time before 11:07:03 am

C. Any time after 11:07:04 am

D. Any time after 11:07:03 am

Which action(s) will cause a compression dictionary to be removed from a table?

A. Set the table COMPRESS attribute to NO.

B. Set the table COMPRESS attribute to NO;run REORG against the table.

C. Set the table COMPRESS attribute to NO;run INSPECTESETDICTIONARY against the table.

D. Set the table COMPRESS attribute to NO;run RUNSTATS against the table.

What would indicate intra-partition parallelism in an Optimizer Plan?

A. BTQ

B. LTQ

C. IP

D. DTQ

Table TAB1 was created using the following statement: CREATE TABLE tab1 (c1 INT, c2 INT, c3 INT, c4 INT, c5 INT); If column C1 is unique and queries typically access columns C1, C2, C3 and C4 together, which statement(s) will create index(es) that will provide optimal query performance?

A. CREATE UNIQUE INDEX xtab1 ON tab1 (c1);CREATE INDEX xtab2 ON tab1 (c2) INCLUDE (c3, c4);

B. CREATE UNIQUE INDEX xtab1 ON tab1 (c1) INCLUDE (c2, c3, c4);

C. CREATE UNIQUE INDEX xtab1 ON tab1 (c4, c3, c2, c1);

D. CREATE UNIQUE INDEX xtab1 ON tab1 (c3) INCLUDE (c1, c2, c4);

Which option of the ALTER TABLE statement tells the DB2 optimizer to use an index scan on a table that might vary in size at run time from being empty to containing a large number of rows?

A. CARDINALITY VOLATILE

B. INDEXSCAN

C. VOLATILE

D. CURRENT CARDINALITY

Given the following table definition in a multi-partitioned database: Which column(s) will be chosen by DB2 as a distribution key (partitioning key)?

A. SS_ID

B. EMP_ID

C. NAME

D. SS_ID, EMP_ID, and NAME

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

Click the Exhibit button.

In a DB2 Connect scenario between a Windows client and a z/OS server, the commands in the exhibit produced an SQL30061N error while trying to connect to the BIGDB001 database in the DB2T subsystem on the z/OS server: SQL30061N The database alias or database name name was not found at the remote node. Explanation: The database name is not an existing database at the remote database node. The statement cannot be processed. The z/OS DBA has confirmed that the LOCATION NAME is DB2T. Which change would enable the command in the exhibit to execute correctly?

A. CATALOG DATABASE bigdb001 AS dsample AT NODE db2t AUTHENTICATION DCS

B. CATALOG DCS DATABASE dsample AS db2t

C. CATALOG DCS DATABASE db2t AS dsample

D. CATALOG DATABASE db2t AS dsample AT NODE node001 AUTHENTICATION DCS