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…

Submitted by suresh_in· Mar 6, 2026Implement and manage an Azure SQL Database environment, including configuring automatic tuning features to optimize database performance and maintain index health.

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. Answer: You can go to Azure portal, and enable Azure SQL Database to automatically create or drop indexes: Step 1: To enable automatic tuning on a server in Azure SQL Database, navigate to the server in the Azure portal. [Here navigate to sql12345678] Step 2: Select Automatic tuning in the menu. Step 3: Change the setting for "Drop Index" to On. Reference: https://techcommunity.microsoft.com/t5/azure-sql-blog/automatic-index-management-in-azure- sql-database/ba-p/386140 https://learn.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-enable?

Exhibit

Explanation

The correct approach uses Azure SQL Database's built-in Automatic Tuning feature, which includes a 'Drop Index' option that monitors index usage patterns and automatically removes indexes that are not being used by queries. By navigating to the SQL server (sql12345678) in the Azure portal, selecting 'Automatic tuning,' and enabling 'Drop Index,' Azure will continuously analyze index usage and drop unused indexes without manual intervention. This is the native, recommended Azure solution for automated index lifecycle management at the server level, applying the policy across all databases hosted on that server.

Topics

#Azure SQL Database#Automatic Tuning#Index Management#Azure Portal Administration

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice