DP-300 Automated database restart via CLI Practice Question
Which TWO methods can be used to automatically restart an Azure SQL Database after a maintenance operation?
⚠ Common exam trap
Candidates may mistakenly think only the Azure CLI pause/resume is automated, but Azure Automation runbooks with PowerShell cmdlets like Start-AzSqlDatabase also provide an automated restart method.
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 CLI az sql db pause/resume
The Azure CLI `az sql db pause/resume` can be scripted and automated, effectively restarting the database. Option E is also correct because an Azure Automation runbook can use the `Start-AzSqlDatabase` cmdlet (and corresponding `Stop-AzSqlDatabase`) to stop and start the database, which achieves an automated restart. Options B, C, and D are incorrect: B is manual via the portal, C is manual via SSMS, and D's `ALTER DATABASE SET ONLINE` does not restart the database.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Azure CLI az sql db pause/resume
Why this is correct
Correct. The Azure CLI pause/resume commands can be scripted in automated workflows.
- ✗
Azure Portal stop/start
Why it's wrong here
Incorrect. The Azure Portal stop/start is a manual action and cannot be automated without additional scripting outside the portal.
- ✗
SQL Server Management Studio (SSMS) restart command
Why it's wrong here
Incorrect. SSMS restart is a manual operation, not automated.
- ✗
Elastic Database Job with ALTER DATABASE SET ONLINE
Why it's wrong here
Incorrect. Elastic Database Jobs with ALTER DATABASE SET ONLINE only set the database online, they do not restart it.
- ✓
Azure Automation runbook with Start-AzSqlDatabase
Why this is correct
Correct. An Azure Automation runbook can use Start-AzSqlDatabase (and Stop-AzSqlDatabase) to automate a database restart.
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
One of 906 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 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.