Microsoft
70-451 · Question #74
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…
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.
How the community answered
(26 responses)- A4% (1)
- B4% (1)
- C81% (21)
- D12% (3)
Community Discussion
No community discussion yet for this question.