Question 781 of 919
DP-300 Plan and implement data platform resources Practice Question
Exhibit
Refer to the exhibit.
```json
{
"properties": {
"storageAccountUri": "https://mystorageaccount.blob.core.windows.net/backups",
"retentionDays": 30,
"storageAccountAccessKey": "..."
}
}
```You are configuring managed backup for an Azure SQL Managed Instance as shown in the exhibit. What is the purpose of this configuration?
⚠ Common exam trap
Watch out — candidates often confuse the purpose of configuring automated backups (which creates the backup chain) with the point-in-time restore feature (which uses that chain), leading them to select Option D instead of the correct Option B.
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
✓
To configure automated backups of the managed instance to Azure Blob Storage.
The configuration shown in the exhibit is for managed backup, which automatically schedules and stores full, differential, and transaction log backups of the Azure SQL Managed Instance to Azure Blob Storage. This ensures that backups are retained and available for restore operations without manual intervention, fulfilling the core purpose of automated backups to Azure Blob Storage.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
To enable geo-replication for the managed instance.
Why it's wrong here
Geo-replication is configured separately.
- ✓
To configure automated backups of the managed instance to Azure Blob Storage.
Why this is correct
Managed backup stores backups in Azure Blob Storage.
- ✗
To set up disaster recovery across Azure regions.
Why it's wrong here
This is for backup storage, not disaster recovery.
- ✗
To configure point-in-time restore for the managed instance.
Why it's wrong here
Point-in-time restore is enabled by automated backups.
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 |
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Last reviewed: Jun 24, 2026
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.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.