Microsoft
70-459 · Question #24
70-459 Question #24: Real Exam Question with Answer & Explanation
Sign in or unlock 70-459 to reveal the answer and full explanation for question #24. The question stem and answer options stay visible for context.
Question
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?
Exhibit
Options
- ACREATE INDEX IX_Table1 ON Table1 (Column1)
- BCREATE INDEX IX_Table1 ON Table1 (Coiumn2)
- CCREATE INDEX IX_Table1 ON Table1 (Column2)
- DCREATE INDEX IX_Table1 ON Table1 (Column2)
Unlock 70-459 to see the answer
You've previewed enough free 70-459 questions. Unlock 70-459 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.