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.