You are designing the storage scheme for a new SQL Server 2008 database application.
The application will primarily be used to query data. The database will be initially populated
with 4 terabytes of data stored in 20 tables. The data is distributed evenly throughout all 20
tables. Every night, between 100 GB and 300 GB of new data will be loaded into 4 database
tables. The remaining 16 tables will remain static. The average CPU utilization of the server
where the application will reside is between 30 and 50 percent. You need to ensure that the
amount of disk space used is reduced. You need to achieve this goal by ensuring minimum
impact of performance on the server. What should you do? (More than one answer choice
may achieve the goal. Select the BEST answer.)
A.
Use row-level data compression on the 4 tables that are loaded every night.
B.
Use page-level data compression on the 16 tables that remain static.
C.
Use row-level data compression on the 16 tables that remain static.
D.
Use page-level data compression on the 4 tables that are loaded every night.