You are a professional level SQL Sever 2008 Database Administrator. The largest table in a
database is partitioned into four equal-sized parts. The first two partitions are seldom
queried, while the third partition is regularly queried by several reports. Meanwhile, the
fourth partition is heavily queried and regularly modified. The disk space of the table should
be cut to the least and the query performance should be with the least impact. What will you
do? (Choose more
A.
PAGE compression should be enabled for the first two partitions.
B.
ROW compression should be enabled for the last partition.
C.
ROW compression should be enabled for the third partition.
D.
ROW compression should be enabled for the first two partitions.
E.
PAGE compression should be enabled for the last partition.
Explanation: