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: