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

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?

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.



Leave a Reply 2

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