PrepAway - Latest Free Exam Questions & Answers

You need to ensure that the minimum amount of disk spac…

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?

PrepAway - Latest Free Exam Questions & Answers

A.
Convert all indexes to Column Store indexes.

B.
Implement Unicode Compression.

C.
Implement row-level compression.

D.
Implement page-level compression.

Explanation:
http://msdn.microsoft.com/en-us/library/cc280449.aspx
http://msdn.microsoft.com/en-us/library/cc280464.aspx
http://msdn.microsoft.com/en-us/library/cc280576.aspx
http://msdn.microsoft.com/en-us/library/ee240835.aspx


Leave a Reply