SIMULATION You need to ensure that indexes are created automatically for all the databases on sql12345678. You may need to use SQL Server Management Studio and the Azure portal. Answer: Automatic…

Submitted by ngozi_ng· Mar 6, 2026Implement and manage a relational database infrastructure in Azure - specifically configuring automatic tuning features to optimize database performance at the server level

Question

SIMULATION You need to ensure that indexes are created automatically for all the databases on sql12345678. You may need to use SQL Server Management Studio and the Azure portal. Answer: Automatic tuning SQL Server identifies and fixes performance issues caused by query execution plan choice regressions. Automatic tuning in Azure SQL Database and SQL database in Microsoft Fabric also creates necessary indexes and drops unused indexes. Step 1: To enable automatic tuning on a server in Azure SQL Database, navigate to the server in the Azure portal [Select sql12345678] and then select Automatic tuning in the menu. Step 2: Select CREATE_INDEX, and change it to enabled. Enable automatic tuning on server On the server level, you can choose to inherit automatic tuning configuration from "Azure Defaults" or not to inherit the configuration. Azure defaults are FORCE_LAST_GOOD_PLAN enabled, CREATE_INDEX disabled, and DROP_INDEX disabled. Step 3: Click the Apply button. Automatic tuning options on a server are applied to all databases on this server. By default, all databases inherit configuration from their parent server, but this can be overridden and specified for each database individually. Reference: https://learn.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-enable

Exhibit

Explanation

Enabling CREATE_INDEX under Automatic Tuning at the server level in the Azure portal is the correct approach because Azure SQL Database's automatic tuning feature monitors query workloads and automatically creates indexes that improve performance across all databases inheriting the server-level configuration. By navigating to sql12345678 in the Azure portal, selecting Automatic Tuning, enabling CREATE_INDEX, and clicking Apply, the setting cascades down to all databases on that server that are configured to inherit from the server defaults. This is the designated Azure-native mechanism for automating index management without manual intervention per database.

Topics

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

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice