You need to ensure that the minimum amount of disk space is used to store the data in the Product table

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?

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?

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 3

Your email address will not be published. Required fields are marked *


Google

Google

Every once in a whilst we select blogs that we study. Listed below are the most recent internet sites that we opt for.