Which code segment should you execute?

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

You add 1 million rows to Table1. Approximately 85 percent of all the rows have a null value for Column2.
You plan to deploy an application that will search Column2.
You need to create an index on Table1 to support the planned deployment. The solution must minimize the
storage requirements.
Which code segment should you execute?

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

You add 1 million rows to Table1. Approximately 85 percent of all the rows have a null value for Column2.
You plan to deploy an application that will search Column2.
You need to create an index on Table1 to support the planned deployment. The solution must minimize the
storage requirements.
Which code segment should you execute?

A.
CREATE INDEX IX_Table1 ON Table1 (Column2)
WITH FILLFACTOR-0

B.
CREATE INDEX IX_Table1 OK Table1 (Column1)
INCLUDE (Column2)

C.
CREATE INDEX IX_Table1 ON Table1 (Column2)
WHERE Column2 IS NULL

D.
CREATE INDEX IX_Table1 ON Table1 (Column2)
WHERE Column2 IS NOT NULL

Explanation:
http://msdn.microsoft.com/en-us/library/ms188783.aspx
http://msdn.microsoft.com/en-us/library/cc280372.aspx



Leave a Reply 0

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