Câu 51: 70-464: Developing Microsoft SQL Server 2012/2014 Databases

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?

1. A. CREATE INDEX IX_Customers ON Customers (FaxNumber) WHERE FaxNumber IS NOT NULL — đáp án hiện tại
2. B. CREATE INDEX IX_Customers ON Customers (FaxNumber) WITH FILLFACTOR=0
3. C. CREATE INDEX IX_Customers ON Customers (CustomerName) INCLUDE (FaxNumber)
4. D. CREATE INDEX IX_Customers ON Customers (FaxNumber)
5. E. CREATE INDEX IX_Customers ON Customers (FaxNumber) WHERE FaxNumber IS NULL