Microsoft
70-450 · Question #42
70-450 Question #42: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #42. The question stem and answer options stay visible for context.
Question
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.)
Options
- AUse page-level data compression on the 4 tables that are loaded every night.
- BUse row-level data compression on the 4 tables that are loaded every night.
- CUse page-level data compression on the 16 tables that remain static.
- DUse row-level data compression on the 16 tables that remain static.
Unlock 70-450 to see the answer
You've previewed enough free 70-450 questions. Unlock 70-450 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.