DP-300 · Question #363
DP-300 Question #363: Real Exam Question with Answer & Explanation
Sign in or unlock DP-300 to reveal the answer and full explanation for question #363. The question stem and answer options stay visible for context.
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?
Options
- taskEnsure that any unused indexes of the databases on sql12345678 are removed automatically.
- prerequisitesSign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
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.