Microsoft
MB6-890 · Question #21
MB6-890 Question #21: Real Exam Question with Answer & Explanation
Sign in or unlock MB6-890 to reveal the answer and full explanation for question #21. The question stem and answer options stay visible for context.
Question
A table named VendTable contains a field named MainContactWorker. which is the reference Recid. Many records in VendTable have the same value for MainContactWorker. Users frequently search for data in VendTable based on the MainContactWorker field. You need to ensure that when users make Queries that include the MainContactWorker field in the where clause, the query results are returned in the least amount of time possible. What should you create on VendTable?
Options
- Aa Surrogate Key that is used as the primary index
- Ba unique index on MainContactWorker
- Ca non-unique index on MainContactWorker
- Da primary index on MainContactWorker
Unlock MB6-890 to see the answer
You've previewed enough free MB6-890 questions. Unlock MB6-890 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.