Microsoft
70-451 · Question #103
70-451 Question #103: Real Exam Question with Answer & Explanation
Sign in or unlock 70-451 to reveal the answer and full explanation for question #103. The question stem and answer options stay visible for context.
Question
You have an execution plan as shown in the exhibit. (Click the Exhibit button.) The indexes and keys for the table are as follows: - Unique index on Col1 and CoI2 - Primary key of table not modifiable - Clustered primary key on Col1 and Col2 You need to recommend changes to the table to minimize the response time for both queries. What should you do?
Exhibit
Options
- AInclude all the columns of the table in the existing nonclustered index.
- Bchange the order of the columns in the existing nonclustered index.
- CAdd a unique nonclustered index to Col1 and Col2.
- DRemove the nonclustered index.
Unlock 70-451 to see the answer
You've previewed enough free 70-451 questions. Unlock 70-451 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.