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 data in one column comes from an expression that uses other columns in the same
table.
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 Persisted Computed property for the column.
B.
You should configure the With Values property for the column.
C.
You should configure the Sparse property for the column.
D.
You should configure the Computed property for the column.
Explanation: