HOTSPOT
You use SQL Server 2014. You create a table within a database by using the following DDL:
The following table illustrates a representative sample of data:
The system is expected to handle 50 million orders a month over the next five years.
You have been instructed by your Team Lead to follow best practices for storage and performance in the
utilization of SPARSE columns.
Which columns should you designate as SPARSE? To answer, mark each column as SPARSE or NOT
SPARSE in the answer area.
Hot Area:
Answer: 
Explanation:
Note:
Sparse columns are ordinary columns that have an optimized storage for null values. Sparse columns reduce
the space requirements for null values at the cost of more overhead to retrieve nonnull values. Consider using
sparse columns when the space saved is at least 20 percent to 40 percent.
Use Sparse Columns
TaxAmount is computed column and can’t be SPARSE
https://blog.sqlauthority.com/2015/06/02/sql-server-errors-and-limitations-of-working-with-sparse-columns-in-sql-server/
2
0
+1
As per Microsoft docs:
“Although a computed column can contain a sparse column, a computed column cannot be marked as SPARSE.”
https://docs.microsoft.com/en-us/sql/relational-databases/tables/use-sparse-columns?view=sql-server-2014
Only IsTaxable and Freight columns can be SPARSE.
1
0