Microsoft
70-583 · Question #66
70-583 Question #66: Real Exam Question with Answer & Explanation
Sign in or unlock 70-583 to reveal the answer and full explanation for question #66. The question stem and answer options stay visible for context.
Question
You are analyzing the performance of a SQL Azure database. You need to recommend an approach for identifying the indexes that should be added to improve database performance. What should you recommend?
Options
- AUse SQL Server Profiler to identify missing indexes.
- BUse the Database Engine Tuning Advisor to identify missing indexes.
- CUse a Dynamic Management View to analyze query plans.
- DUse a Dynamic Management View to ascertain the number of pending I/O requests.
Unlock 70-583 to see the answer
You've previewed enough free 70-583 questions. Unlock 70-583 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.