Microsoft
70-451 · Question #74
70-451 Question #74: Real Exam Question with Answer & Explanation
The correct answer is C. Use row compression.. See the full explanation below for the reasoning.
Question
You are designing a database that will be used for reporting purposes. The database stores data using spatial data type. You need to minimize the data storage requirements and improve the application response time. What should you recommend?
Options
- AUse XML datatype.
- BUse table partitioning.
- CUse row compression.
- DUse sparse columns.
Community Discussion
No community discussion yet for this question.