You have a SQL Azure database. You execute the following code: The Sales.Customers table will contain 100,000 rows. You

[answerhappygod]

You have a SQL Azure database.
You execute the following code:

The Sales.Customers table will contain 100,000 rows. You expect the FaxNumber column to contain a null value for 70 percent of the rows.
You need to create an index to support Sales.CustomersByFaxNumber. The solution must minimize the disk storage requirements.
Which code segment should you execute?

You Have A Sql 1 (80.95 KiB) Viewed 108 times

A. CREATE INDEX IX_Customers ON Customers (FaxNumber) WHERE FaxNumber IS NOT NULL
B. CREATE INDEX IX_Customers ON Customers (FaxNumber) WITH FILLFACTOR=0
C. CREATE INDEX IX_Customers ON Customers (CustomerName) INCLUDE (FaxNumber)
D. CREATE INDEX IX_Customers ON Customers (FaxNumber)
E. CREATE INDEX IX_Customers ON Customers (FaxNumber) WHERE FaxNumber IS NULL