You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 sample that contains an On-Line Analytical Processing (OLAP) database and a dimension table named CK_TST.
CK_TST contains data that is not in use, but you refresh the table on an hourly basis.
Consequently this results in a large chunk of disk space being taken up by superfluous data.
You need to keep the disk space that will be used to reserve the CK_TST table.
What should you do?
A.
You should consider using Page compression.
B.
You should consider using Windows NTFS file system compression.
C.
You should consider using Transaction compression.
D.
You should consider using Row compression.