You work as a Database Administrator (DBA) at ABC.com. All databases are hosted on Windows
Server 2012 servers running SQL Server 2012.
You create a table named Orders in a database named SalesDB1. The table includes a column
named Date which has the NULL and SPARSE options configured.
You populate the Orders table with 1 million rows of order data. More than 800,000 rows do not
have a value in the Date column.
You need to create an index for the Orders table.
You need to optimize the index so that the storage space used by the index is minimized.
Which of the following statements should you use to create the index?
A.
CREATE INDEX IX_Orders ON Orders (Date)
WITH FILLFACTOR=0
B.
CREATE INDEX IX_Orders ON Orders (Date)
WITH FILLFACTOR=80
C.
CREATE INDEX IX_Orders ON Orders (Date)
WHERE Date IS NULL
D.
CREATE INDEX IX_Orders ON Orders (Date)
WHERE Date IS NOT NULL
Explanation: