DP-300 · Question #163
DP-300 Question #163: Real Exam Question with Answer & Explanation
The correct answer is C: Modify the automatic tuning settings for db1.. Automatic tuning is a fully managed intelligent performance service that uses built-in intelligence to continuously monitor queries executed on a database, and it automatically improves their Automatic tuning for Azure SQL Database uses the CREATE INDEX, DROP INDEX, and FORCE LAS
Question
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?
Options
- ARun the DBCC SQLPERF command.
- BRun the DBCC DBREINDEX command.
- CModify the automatic tuning settings for db1.
- DModify the Query Store settings for db1.
Explanation
Automatic tuning is a fully managed intelligent performance service that uses built-in intelligence to continuously monitor queries executed on a database, and it automatically improves their Automatic tuning for Azure SQL Database uses the CREATE INDEX, DROP INDEX, and FORCE LAST GOOD PLAN database advisor recommendations to optimize your database performance. https://docs.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-overview
Community Discussion
No community discussion yet for this question.