Microsoft
70-451 · Question #103
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…
The correct answer is C. Add a unique nonclustered index to Col1 and Col2. See the full explanation below for the reasoning.
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.
How the community answered
(40 responses)- A15% (6)
- B8% (3)
- C73% (29)
- D5% (2)
Community Discussion
No community discussion yet for this question.