Pass with professional C2090-544 actual quiz materials

IBM C2090-544 Exam Overview:

IBM C2090-544 Exam Syllabus Topics:

IBM DB2 9.7 Advanced DBA for LUW Sample Questions:

Question 1

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 data 2) Load July 2010 data into a new table 3) Attach the new table as a new partition in the existing partitioned table 4) Check constraint integrity for the partitioned table
B. 1) Detach partition containing July 2005 data 2) Load July 2010 data into a new table 3) Attach the new table as a new partition in the existing partitioned table 4) Rebind the partitioned table
C. 1) Detach partition containing July 2005 data 2) Load July 2010 data into a new table 3) Attach the new table as a new partition in the existing partitioned table 4) Reorg the partitioned table
D. 1) Detach partition containing July 2005 data 2) Load July 2010 data into a new table 3) Attach the new table as a new partition in the existing partitioned table 4) Update statistics on the partitioned table

Question 2

Table T1 was created by executing the following statement:

Immediately after creation, table T1 was populated with 10 rows. Later, user USER1 ran an application that inserted 100,000 rows into table T1. The following query is frequently ran against the T1 table:
SELECT deptno, empno, deptname FROM t1 WHERE deptno = 'EN' AND empno = '123' Assuming current statics exist for the table and index, which index will provide optimal performance for this query?

A. CREATE INDEX idx1 ON t1 (deptno, empno) INCLUDE (deptname)
B. CREATE INDEX idx1 ON t1 (deptno)
C. CREATE INDEX idx1 ON t1 (deptno, empno)
D. CREATE INDEX idx1 ON t1 (deptno) INCLUDE (empno)

Question 3

The DBA needs to create a table with key columns YEARDAY, YEAR, and DAY. This table needs to be partitioned by column YEARDAY with three months per data partition. Additionally, data needs to be organized 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
(yearday INT,
year CHAR(2),
day INT))
PARTITION BY RANGE (year) (STARTING 201001 ENDING 201012 EVERY 3)
ORGANIZE BY DIMENSIONS (year, day))
B. CREATE TABLE tab1
(yearday INT,
year CHAR(2),
day INT))
PARTITION BY RANGE (yearday) (STARTING 201001 ENDING 201012 EVERY 3)
ORGANIZE BY DIMENSIONS (day))
C. CREATE TABLE tab1
(yearday INT,
year CHAR(2),
day INT))
PARTITION BY RANGE (yearday) (STARTING 201001 ENDING 201012 EVERY 3)
ORGANIZE BY DIMENSIONS (year))
D. CREATE TABLE tab1
(yearday INT,
year CHAR(2),
day INT))
PARTITION BY RANGE (yearday) (STARTING 201001 ENDING 201012 EVERY 3)
ORGANIZE BY DIMENSIONS (year, day))

Question 4

Assuming table TAB_A resides in a DB2 9.7 database, what is one way to obtain an estimate of how much space could be saved if this table were compressed?

A. The ADMINGETTABCOMPRESSINFO table function.
B. The ADMIN_GET_TAB_COMPRESS_INFO_V97 table function.
C. The ADMINGETTABCOMPRESSINFO_V97 table function.
D. The ADMIN_GET_TAB_INFO table function.

Question 5

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_SHR
B. SORTHEAP
C. SHEAPTHRES
D. SHEAPTHRES_SHR

Solutions: