DP-300 Certification Practice Question #206

Question

SIMULATION
 -

You need to ensure that any unused indexes of the databases on sql12345678 are removed automatically.

To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.

Accepted Answer

To ensure that unused indexes are automatically removed from the databases on the logical server, you must leverage Azure SQL Database's native **Automatic Tuning** feature. In the Azure portal (or using T-SQL/PowerShell), you navigate to the automatic tuning configuration at either the server level (to apply to all databases) or the individual database level, and configure the **DROP_INDEX** option to **ON** (or inherit from server where it is ON). This allows the system to monitor index usage over a 90-day period and autonomously drop unused or duplicate indexes to optimize write performance, while automatically reverting changes if a regression is detected.

More DP-300 practice questions