DP-300 Configure and manage automation of tasks Practice Question
A company uses Azure SQL Database and wants to automate the process of refreshing a development database from production backups weekly. Which Azure service should be used to orchestrate this process including restore and post-restore scripts?
⚠ Common exam trap
DP-300 often tests the distinction between orchestration tools — candidates confuse Elastic Database Jobs (T-SQL only) with Azure Automation (external scripting), picking the former because it sounds database-specific.
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
✓
Azure Automation with PowerShell runbooks
Azure Automation with PowerShell runbooks is designed for orchestrating scheduled administrative tasks across Azure resources, including database restore operations and post-restore T-SQL scripts. It supports credentials, schedules, and integration with Azure SQL via the SqlServer module, making it the right tool for weekly refresh automation.
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
Why it's wrong here
Elastic Database Jobs run T-SQL against Azure SQL databases, but they cannot restore a database from a backup or run external post-restore scripts. It is tempting because it targets Azure SQL Database directly, and it would be correct for scheduled T-SQL maintenance such as index rebuilds across a pool.
- ✗
Azure Logic Apps
Why it's wrong here
Logic Apps provide connectors and workflow branching, but they cannot natively perform an Azure SQL Database point-in-time restore or execute T-SQL post-restore scripts as first-class actions. It is tempting because it orchestrates multi-step workflows, and it would be correct for integrating SaaS APIs or approval flows rather than database restores.
- ✓
Azure Automation with PowerShell runbooks
Why this is correct
Azure Automation runbooks execute scheduled PowerShell that can invoke Az.Sql cmdlets to restore the production backup and then run post-restore T-SQL scripts. This satisfies the orchestration requirement spanning restore plus subsequent scripting, which a plain backup policy alone cannot perform.
- ✗
Azure Data Factory
Why it's wrong here
Azure Data Factory moves and transforms data; it cannot restore an Azure SQL Database from a backup. It is tempting because it schedules pipelines and runs activities, and it would be correct for copying or transforming data between stores, not for the restore operation the scenario requires.
Go deeper
Related to this question
Learn chapter
Configuring Automation Tasks for Database Administration
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
One of 574 original DP-300 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Microsoft exam blueprint
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.