DP-300 Certification Practice Question #132

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?

Accepted Answer

Azure SQL Database has built-in automatic tuning capabilities that can dynamically optimize database performance. One of the automatic tuning options is `CREATE_INDEX`, which automatically identifies missing indexes that would improve query performance, creates them, and verifies that they provide a net positive performance impact. Enabling or modifying the automatic tuning settings for `db1` to turn on `CREATE_INDEX` is the correct action to ensure missing indexes are automatically created.

More DP-300 practice questions