What should you do?

You have an Azure SQL database named db1 on a server named server1.

The Intelligent Insights diagnostics log identifies that several tables are missing indexes.

You need to ensure that indexes are created for the tables.

What should you do?
A . RuntheDBCC SQLPERF command.
B. Run the dbcc dbreindex command.
C. Modify the automatic tuning settings for db1.
D. Modify the Query Store settings for db1.

View Answer

Answer: C

Explanation:

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