DP-300 Configure and manage automation of tasks Practice Question
You have an Azure SQL Database that uses a failover group for high availability. You need to automate the failover to the secondary region during a planned maintenance window. What is the best approach?
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
✓
Use Azure CLI or PowerShell to invoke planned failover
Azure SQL Database failover groups support planned failover via Azure CLI or PowerShell, which can be automated. Option B is wrong because Azure Automation runbooks can also be used, but the CLI is more direct. Option C is wrong because Elastic Jobs are not for failover. Option D is wrong because Azure Traffic Manager is for DNS-level traffic routing, not database failover.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Use Azure CLI or PowerShell to invoke planned failover
Why this is correct
Failover groups support automated planned failover via CLI/PowerShell.
- ✗
Create an Azure Automation runbook that uses REST API
Why it's wrong here
Using REST API calls from an Azure Automation runbook lacks the built-in coordinated data loss handling and automatic DNS update that a planned failover via the failover group’s `failover` command provides. It is tempting because REST APIs offer granular control over individual database operations, and would be correct for orchestrating custom recovery workflows not covered by the failover group’s native mechanisms.
- ✗
Schedule an Elastic Database Job to execute a failover script
Why it's wrong here
Elastic Jobs cannot perform failover.
- ✗
Configure Azure Traffic Manager to route traffic to secondary
Why it's wrong here
Traffic Manager is for web traffic, not database failover.
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.