Which columns should you designate as SPARSE?

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:


microsoft-exams

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.