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 page-level data compression on the 4 tables that are loaded every night.
B.
Use row-level data compression on the 4 tables that are loaded every night.
C.
Use page-level data compression on the 16 tables that remain static.
D.
Use row-level data compression on the 16 tables that remain static.
How can applying page-level compression to the most volatile tables meet the goal of ensuring minimum performance impact on the server. How can applying NO compression to the 16 static tables meet the goal of reducing disk space usage?
This is utterly ridiculous!