Microsoft
70-451 · Question #135
You are designing a database that will be used for reporting purposes. You need to minimize the data storage requirements and improve the application response time. What should you recommend?
The correct answer is A. row compression. See the full explanation below for the reasoning.
Question
You are designing a database that will be used for reporting purposes. You need to minimize the data storage requirements and improve the application response time. What should you recommend?
Options
- Arow compression
- Bsparse columns
- Ctable partitioning
- DXML
How the community answered
(56 responses)- A84% (47)
- B2% (1)
- C11% (6)
- D4% (2)
Community Discussion
No community discussion yet for this question.