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.
Answer: C
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-overview
Latest DP-300 Dumps Valid Version with 176 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund