Many people know getting IBM certification is very useful for their career but they fear failure because they hear it is difficult. Now I advise you to purchase our A2090-544 premium VCE file. If you are not sure you can download our A2090-544 VCE file free for reference. Please trust me if you pay attention on our A2090-544 dumps VCE pdf you will not fail. We can guarantee you pass A2090-544 exam 100%.

Why do we have this confidence to say that we are the best for A2090-544 exam and we make sure you pass exam 100%? Because our premium VCE file has 80%-90% similarity with the real IBM A2090-544 questions and answers. Once you finish our A2090-544 dumps VCE pdf and master its key knowledge you will pass A2090-544 exam easily. If you can recite all A2090-544 dumps questions and answers you will get a very high score. Our standard is that No Help, Full Refund. No pass, No pay.

Instant Download: Our system will send you the A2090-544 braindumps file you purchase in mailbox in a minute after payment. (If not received within 12 hours, please contact us. Note: don't forget to check your spam.)

IBM A2090-544 Exam Syllabus Topics:

IBM Assessment: DB2 9.7 Advanced DBA for LUW Sample Questions:

1. Which statement about compression and temporary tables is NOT correct?

A) The explain facility and the db2pd utility can be used to determine whether a temporary table has been compressed.
B) Compression is only applied to created temporary tables that were defined with the CREATE TEMPORARY TABLE ?COMPRESS YES statement.
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.

2. 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 3)
ORGANIZE BY DIMENSIONS (year))
D) CREATE TABLE tab1
(yearmonth INT,
year CHAR(2))
PARTITION BY RANGE (yearmonth) (STARTING 201001 ENDING 201012 EVERY 12)
ORGANIZE BY DIMENSIONS (year))

3. A table named TAB_A was created with the COMPRESS YES option specified and populated with 100,000 rows. If a DBA wants to create an index on table TAB_A, which statement is true?

A) In order for the index to be compressed, it must be enabled for compression by specifying the COMPRESS YES option with the CREATE INDEX statement that is used to create it.
B) The index will automatically be compressed since the table it is associated with is compressed; the ALTER INDEX command does not have to be executed.
C) The index will automatically be enabled for compression because the associated table is compressed; however, the index will not be compressed until it is REORGed.
D) In order for the index to be compressed, it must be enabled for compression by specifying the COMPRESS YES option in the CREATE INDEX statement used to create it; however, the index will not be compressed until the ALTER INDEX command is used to create an index compression dictionary.

4. 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 (yearday) (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 (year) (STARTING 201001 ENDING 201012 EVERY 3)
ORGANIZE BY DIMENSIONS (year, day))
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))

5. Which option of the REORG TABLE statement will release blocks that contain no rows from a multi-dimensional clustering (MDC) table?

A) RECLAIM FREE BLOCKS
B) RELEASE FREE BLOCKS ONLY
C) RECLAIM EXTENTS ONLY
D) RELEASE FREE EXTENTS ONLY

Solutions: