Microsoft
MB6-890 · Question #21
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…
The correct answer is C. a non-unique index on MainContactWorker. See the full explanation below for the reasoning.
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
How the community answered
(45 responses)- A4% (2)
- B16% (7)
- C73% (33)
- D7% (3)
Community Discussion
No community discussion yet for this question.