Microsoft
70-433 · Question #32
You have a database that uses stored procedures to perform INSERT, UPDATE, DELETE, and SELECT statements. You are tasked with providing a recommendation of indexes to be created and dropped from the…
The correct answer is D. Database Engine Tuning Advisor. See the full explanation below for the reasoning.
Question
You have a database that uses stored procedures to perform INSERT, UPDATE, DELETE, and SELECT statements. You are tasked with providing a recommendation of indexes to be created and dropped from the database. You need to select the appropriate method to accomplish the task. Which method should you use?
Options
- AIndex Usage DMVs
- BMissing Index DMVs
- CSQL Server Profiler
- DDatabase Engine Tuning Advisor
How the community answered
(29 responses)- A14% (4)
- B10% (3)
- C3% (1)
- D72% (21)
Community Discussion
No community discussion yet for this question.