Microsoft
70-457 · Question #38
You administer a Microsoft SQL Server 2012 database. The database contains a Product table created by using the following definition: You need to ensure that the minimum amount of disk space is used…
The correct answer is D. Implement page-level compression. See the full explanation below for the reasoning.
Question
You administer a Microsoft SQL Server 2012 database. The database contains a Product table created by using the following definition:
You need to ensure that the minimum amount of disk space is used to store the data in the Product table. What should you do?
Exhibit
Options
- AConvert all indexes to Column Store indexes.
- BImplement Unicode Compression.
- CImplement row-level compression.
- DImplement page-level compression.
How the community answered
(53 responses)- A4% (2)
- B6% (3)
- C15% (8)
- D75% (40)
Community Discussion
No community discussion yet for this question.