nerdexam
Microsoft

70-451 · Question #51

70-451 Question #51: Real Exam Question with Answer & Explanation

The correct answer is B. filtered. See the full explanation below for the reasoning.

Question

You have a table that contains 5 million rows. The table has a clustered index. You plan to add an additional index on a column that contains 80 percent null values. The column is used extensively in WHERE clauses. You need to implement an index strategy for the column. The solution must minimize the amount of storage space required for the index. Which type of index should you use?

Options

  • Aclustered
  • Bfiltered
  • Cnonclustered
  • Dunique

Community Discussion

No community discussion yet for this question.

Full 70-451 Practice