DP-300 Configure and manage automation of tasks Practice Question
You are managing an Azure SQL Database that requires automated index maintenance. You want to use a solution that minimizes administrative overhead and leverages built-in Azure capabilities. Which approach should you recommend?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Enable automatic tuning for the database and configure the 'CREATE INDEX' and 'DROP INDEX' recommendations.
Azure SQL Database's automatic tuning feature can automatically create and drop indexes based on workload patterns, minimizing administrative overhead and leveraging built-in Azure capabilities. Option B is incorrect because deploying a third-party solution would introduce additional complexity and cost, not leveraging built-in capabilities. Option C is incorrect because although Azure Automation can schedule scripts, it still requires custom scripting and maintenance, increasing overhead compared to fully automated built-in tuning. Option D is incorrect because scheduling a SQL Agent job requires manual setup and is not a built-in automated feature of Azure SQL Database; SQL Agent is available only in managed instances, not in single databases or elastic pools, and requires custom T-SQL scripting.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Enable automatic tuning for the database and configure the 'CREATE INDEX' and 'DROP INDEX' recommendations.
Why this is correct
Automatic tuning handles index management automatically based on workload patterns.
- ✗
Deploy a third-party maintenance solution and connect it to the Azure SQL Database.
Why it's wrong here
Third-party tools add cost and complexity; built-in options are preferred.
- ✗
Create a custom PowerShell script and run it via Azure Automation Runbook on a schedule.
Why it's wrong here
This requires custom development and does not leverage built-in capabilities.
- ✗
Schedule a SQL Agent job to rebuild indexes using a T-SQL script.
Why it's wrong here
SQL Agent jobs are not available in Azure SQL Database single databases; they require managed instances.
Go deeper
Related to this question
Learn chapter
Overview of Azure Data Platform Options
Key term
Azure SQL Performance Tuning
Azure SQL Performance Tuning is the process of optimizing the speed and efficiency of queries and database operations in Microsoft Azure SQL Database or SQL Managed Instance to reduce latency and improve throughput.
About these practice questions
This DP-300 question is part of Courseiva's 906-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-300 exam.