nerdexam
Microsoft

70-459 · Question #24

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…

The correct answer is B. CREATE INDEX IX_Table1 ON Table1 (Coiumn2). See the full explanation below for the reasoning.

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

70-459 question #24 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)

How the community answered

(41 responses)
  • A
    15% (6)
  • B
    73% (30)
  • C
    10% (4)
  • D
    2% (1)

Community Discussion

No community discussion yet for this question.

Full 70-459 Practice