You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle.
In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization.
A SQL Server 2008 infrastructure is managed by you. 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 than one.)
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.
F.
PAGE compression should be enabled for the third partition.