You work as a Database Administrator (DBA) at ABC.com. All databases are hosted on Windows
Server 2012 servers running SQL Server 2012.
You need to create a table for a database. The table will have between 1 million and 5 million
rows. The table will have columns that have null-valued rows 70% of the time.
You need to optimize the table so that the storage space used for each row is minimized.
What should you do?
A.
You should configure the Computed property for the columns.
B.
You should configure the Sparse property for the columns.
C.
You should configure the With Values property for the columns.
D.
You should configure the Check property for the columns.
Explanation: