DP-300 · Question #412
DP-300 Question #412: Real Exam Question with Answer & Explanation
Sign in or unlock DP-300 to reveal the answer and full explanation for question #412. The question stem and answer options stay visible for context.
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
Options
- taskEnsure that indexes are created automatically for all the databases on sql12345678.
- prerequisitesAzure portal access and SQL Server Management Studio
Unlock DP-300 to see the answer
You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.