DP-300 Configure and manage automation of tasks Practice Question
You have an Azure SQL Database that runs a critical workload. You need to automate index maintenance to reduce fragmentation without impacting performance. What should you use?
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
✓
Elastic Database Jobs with T-SQL script
Elastic Database Jobs can be used to schedule and run T-SQL scripts for index maintenance across one or more databases in Azure SQL Database. This allows you to automate index rebuilds or reorganizations during off-peak hours to reduce fragmentation without impacting performance. Option B is incorrect because automatic tuning in Azure SQL Database focuses on creating and dropping indexes based on query patterns, not on rebuilding fragmented indexes. Options C and D are incorrect: SQL Agent Jobs are not available in Azure SQL Database single databases, and while Azure Automation runbooks could be used, Elastic Database Jobs provide a more integrated and seamless solution for database-specific tasks.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Elastic Database Jobs with T-SQL script
Why this is correct
Correct. Elastic Database Jobs allow you to automate T-SQL scripts for index maintenance across Azure SQL databases, enabling scheduling of index rebuilds to reduce fragmentation without performance impact.
- ✗
Automatic tuning for index management
Why it's wrong here
Incorrect. Automatic tuning only manages index creation/dropping based on query performance; it does not rebuild fragmented indexes.
- ✗
SQL Agent Job with OLE Automation
Why it's wrong here
Incorrect. SQL Agent Jobs are not supported in Azure SQL Database single databases; they are available only in SQL Server on-premises or Azure SQL Managed Instance.
- ✗
Azure Automation runbook with T-SQL script
Why it's wrong here
Incorrect. While Azure Automation runbooks can run T-SQL scripts, Elastic Database Jobs are purpose-built for automating database tasks and offer better integration and control.
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.