Exit 70-583 PRO: Designing and Developing Windows Azure Applications
Question 5 of 5
0% complete
Q5 Single choice

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?

  • A

    Use SQL Server Profiler to identify missing indexes.

  • B

    Use the Database Engine Tuning Advisor to identify missing indexes.

  • C

    Use a Dynamic Management View to analyze query plans.

  • D

    Use a Dynamic Management View to ascertain the number of pending I/O requests.

Previous Save & finish