DP-300 Configure and manage automation of tasks Practice Question
Which TWO of the following are valid methods to automate backups for Azure SQL Managed Instance? (Select exactly two.)
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
✓
Schedule T-SQL BACKUP DATABASE TO URL statements via SQL Agent jobs.
Options B and D are correct. Azure SQL Managed Instance supports automated backups through the service's built-in point-in-time restore (PITR) and long-term retention (LTR) policies (option D). Additionally, you can schedule manual copy-only backups to Azure Blob Storage using T-SQL BACKUP DATABASE TO URL statements via SQL Agent jobs (option B). Option A is incorrect because Azure Backup does not natively support Azure SQL Managed Instance. Option C is incorrect because Azure Site Recovery is a disaster recovery solution, not a backup service. Option E is incorrect because Azure VM backup is designed for IaaS virtual machines, not for PaaS managed instances.
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 Backup to schedule full backups.
Why it's wrong here
Azure Backup does not support SQL Managed Instance backup.
- ✓
Schedule T-SQL BACKUP DATABASE TO URL statements via SQL Agent jobs.
Why this is correct
SQL Agent jobs can automate copy-only backups to Azure Blob.
- ✗
Use Azure Site Recovery to replicate the instance.
Why it's wrong here
Site Recovery is for disaster recovery, not backup.
- ✓
Configure long-term retention (LTR) policies on the managed instance.
Why this is correct
LTR is a native backup automation feature for Managed Instance.
- ✗
Use Azure VM backup by installing the backup extension.
Why it's wrong here
VM backup is for virtual machines, not Managed Instance.
Quick reference
Azure Blob Storage Tier Comparison
| Tier | Storage Cost | Retrieval Cost | Latency | Use Case |
|---|---|---|---|---|
| Hot | Highest | Lowest | Immediate | Active data, frequent reads |
| Cool | Lower | Higher | Immediate | Data accessed < once / month |
| Cold | Lower still | Higher | Immediate | Data accessed < once / quarter |
| Archive | Lowest | Highest + rehydration delay | Hours | Long-term compliance retention |
Go deeper
Related to this question
Learn chapter
Overview of Azure Data Platform Options
Key term
Azure SQL Managed Instance
Azure SQL Managed Instance is a fully managed cloud database service that gives you nearly all the features of Microsoft SQL Server on your own server, without you having to manage the hardware or operating system.
Key term
Azure SQL Database Backup
Azure SQL Database Backup is a fully managed, automated service that creates and stores copies of your SQL database data and transaction logs in Azure storage, enabling point-in-time recovery and long-term retention for data protection and business continuity.
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.