You work as a database administrator at ABC.com. ABC.com makes use of a SQL Server 2008
R2 instance that includes an On-Line Analytical Processing (OLAP) database.
The OLAP database hosts a dimension table, named ABCClients, which has hourly information
updates configured. As a result, ABCClients has a large quantity of information that is no longer
used.
You have been instructed to make sure that the amount of space used by the ABCClients table is
reduced with as little administrative effort as possible.
Which of the following actions should you take?
A.
You should consider manually deleting the information that is no longer used.
B.
You should consider making use of page compression.
C.
You should consider making use of the Disk Cleanup Wizard.
D.
You should consider making use of folder compression.
Explanation: