PrepAway - Latest Free Exam Questions & Answers

You need to identify whether adding the index improves …

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?

PrepAway - Latest Free Exam Questions & Answers

A.
Database Engine Tuning Advisor

B.
Index Tuning Wizard

C.
Azure Throughput Analyzer

D.
AzureSQL Database Index Advisor

Explanation:
https://azure.microsoft.com/en-gb/documentation/articles/sql-database-advisor/


Leave a Reply