What should you use?

You need to ensure that the missing indexes for REPORTINGDB are added.

What should you use?
A . SQL Database Advisor
B . extended events
C . Query Performance Insight
D . automatic tuning

View Answer

Answer: D

Explanation:

Automatic tuning options include create index, which identifies indexes that may improve performance of your workload, creates indexes, and automatically verifies that performance of queries has improved.

Scenario:

– REPORTINGDB stores reporting data and contains server columnstore indexes.

– Migrate SALESDB and REPORTINGDB to an Azure SQL database.

References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-automatic-tuning