Plan and implement data platform resources →easyMultiple Choice

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
Managed backup configures automated backup retention and storage redundancy for the instance's databases; geo-replication is a separate feature configured on individual databases, not through backup settings. It is tempting because both concern resilience, and geo-replication would be the right choice when the goal is a readable secondary in another region.
✓
To configure automated backups of the managed instance to Azure Blob Storage.
Why this is correct
Managed backup automates full, differential and transaction log backups of the managed instance directly to Azure Blob Storage, giving retention control without manual jobs. This satisfies the exhibit's configuration purpose of automated backup to blob storage.
✗
To set up disaster recovery across Azure regions.
Why it's wrong here
Managed backup governs automated backup scheduling, retention periods and storage redundancy within the instance; cross-region disaster recovery requires failover groups or geo-replication, which backup settings do not provision. It is tempting because backups underpin recovery, and would be correct if the requirement were simply retaining backups for restore.
✗
To configure point-in-time restore for the managed instance.
Why it's wrong here
Point-in-time restore is a capability enabled by the automated backups that managed backup governs, not its purpose; the configuration sets retention and redundancy policy rather than defining a restore operation. It is tempting because PITR depends on those backups, and would be the right answer if the question asked what the backups enable.

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

DP-300 Plan and implement data platform resources Practice Question

Exhibit

Why each option matters

Option-by-option breakdown

Azure Blob Storage Tier Comparison

Related to this question