nerdexam
IBM

A2090-614 · Question #39

A2090-614 Question #39: Real Exam Question with Answer & Explanation

The correct answer is A. ALTER TABLESPACE ts1 REBALANCE. See the full explanation below for the reasoning.

Question

A storage group named MED_SG was created as follows: CREATE STOGROUP med_sg ON ?db2fs1? ?db2fs2? '/db2fs3' Then, a table space named TS1 was created in the storage group and two tables (TAB_A and TAB_B) were created in the TS1 table space. Four months later, a DBA discovered that 90% of the space that had been allocated to the MED_SG storage group had been consumed. So, more space was added to the storage group by executing the following command: ALTER STOGROUP med_sg ADD ?db2fs4? ALTER STOGROUP med_sg ADD ?db2fs4 Shortly afterwards, queries against tables in the TS1 table space began to run slower. Which statement should be executed to correct the performance problem?

Options

  • AALTER TABLESPACE ts1 REBALANCE
  • BALTER STOGROUP med_sg ADD ?db2fs5?ALTER STOGROUP med_sg ADD ?db2fs5
  • CALTER STOGROUP med_sg DROP '/db2fs4'
  • DALTER TABLESPACE ts1 ADD '/db2fs4' REBALANCE

Community Discussion

No community discussion yet for this question.

Full A2090-614 Practice