Exam DP-300 topic 3 question 27 discussion

Actual exam question from Microsoft's DP-300

Question #: 27
Topic #: 3

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. Run the DBCC SQLPERF command.
B. Run the DBCC DBREINDEX command.
C. Modify the automatic tuning settings for db1.
D. Modify the Query Store settings for db1.

Show Suggested Answer

Suggested Answer: C 🗳️
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 performance.
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.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-overview

by o2091 at Nov. 12, 2021, 10:44 p.m.

Comments

Submit Cancel

vcloudpmp

11 months, 2 weeks ago

https://learn.microsoft.com/en-us/training/modules/configure-databases-for-optimal-performance/4-describe-automatic-tuning

upvoted 1 times

...

Ciupaz

1 year, 8 months ago

Automatic tuning is capable of seamlessly tuning hundreds of thousands of databases without affecting performance of the existing workloads. The solution has been globally available since 2016 and proven to enable performant and stable workloads while reducing resource consumption on Azure.

upvoted 3 times

...

o2091

2 years, 7 months ago

Answer looks correct

upvoted 3 times

...