PrepAway - Latest Free Exam Questions & Answers

Which code segment should you execute?

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?

PrepAway - Latest Free Exam Questions & Answers

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


Leave a Reply