Microsoft
70-473 · Question #6
You have a report that runs against a Microsoft Azure SQL database. The report takes more time to return results than expected. You add an index to a table in the database. You need to identify whethe
The correct answer is D. Azure SQL Database Index Advisor. https://azure.microsoft.com/en-gb/documentation/articles/sql-database-advisor/
Monitor and manage an Azure data platform solution
Question
You have a report that runs against a Microsoft Azure SQL database. The report takes more time to return results than expected. You add an index to a table in the database. You need to identify whether adding the index improves the performance issue. What should you use?
Options
- ADatabase Engine Tuning Advisor
- BIndex Tuning Wizard
- CAzure Throughput Analyzer
- DAzure SQL Database Index Advisor
How the community answered
(27 responses)- A4% (1)
- C4% (1)
- D93% (25)
Explanation
https://azure.microsoft.com/en-gb/documentation/articles/sql-database-advisor/
Topics
#Azure SQL Database performance#Index tuning#Index Advisor
Community Discussion
No community discussion yet for this question.