Microsoft
MB6-894 · Question #87
MB6-894 Question #87: Real Exam Question with Answer & Explanation
Sign in or unlock MB6-894 to reveal the answer and full explanation for question #87. The question stem and answer options stay visible for context.
Question
Your company is having issues with indexes. You research the problem and find that, regardless of index type (primary, clustered, or non-clustered), you do not get the expected performance improvements. To resolve the issue, what should you ensure about the columns of the index?
Options
- AThey have the Allow Duplicates property set to No.
- BThey are arranged from the most granular to the least granular.
- CThey are arranged from the least granular to the most granular.
- DThey are sorted in a different order, based on category.
Unlock MB6-894 to see the answer
You've previewed enough free MB6-894 questions. Unlock MB6-894 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.