DP-300 Configure and manage automation of tasks Practice Question
You are responsible for automating index maintenance and statistics updates across multiple Azure SQL Databases in an elastic pool. Each database has varying workloads and sizes. The automation must run weekly during low-traffic periods and should not degrade performance for critical applications. Which three actions should you take to implement a reliable and efficient automation solution?
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
✓
Create an Azure Automation account and schedule a PowerShell runbook that connects to each database and runs index maintenance scripts.
Azure Automation with PowerShell runbooks allows scheduling and executing T-SQL scripts across databases. Option C is correct because Elastic Database Jobs can target a group of databases in an elastic pool. Option D is correct because automatic tuning can handle index and statistics maintenance, reducing manual effort. Option B is incorrect because SQL Agent jobs are not available in Azure SQL Database (only in Managed Instance) and cannot be used across multiple databases in an elastic pool. Option E is incorrect because auto-failover groups are for high availability and disaster recovery, not for automating maintenance 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.
- ✓
Create an Azure Automation account and schedule a PowerShell runbook that connects to each database and runs index maintenance scripts.
Why this is correct
Azure Automation can execute T-SQL scripts on a schedule.
- ✗
Configure SQL Agent jobs in each database to run the maintenance scripts.
Why it's wrong here
Azure SQL Database does not support SQL Agent.
- ✓
Use Elastic Database Jobs to run T-SQL scripts against all databases in the elastic pool.
Why this is correct
Elastic Database Jobs can execute commands across multiple databases.
- ✓
Enable automatic tuning for index management and statistics update in each database.
Why this is correct
Automatic tuning can handle index and statistics maintenance automatically.
- ✗
Enable auto-failover groups for all databases to automate failover during maintenance.
Why it's wrong here
Auto-failover groups are for high availability, not index maintenance.
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
Courseiva writes every DP-300 question from scratch — 906 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or 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.