What should you do?

You administer a Microsoft SQL Server 2012 database.

The database contains a customer 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 customer table.

What should you do?
A . Implement row-level compression.
B . Implement page-level compression.
C . Convert all indexes to Column Store indexes.
D . Implement Unicode compression.

View Answer

Answer: B