Plan and implement data platform resources →mediumMultiple ChoiceObjective-mapped

DP-300 Plan and implement data platform resources Practice Question

Exhibit

Refer to the exhibit.

Exhibit:
```
{
    "properties": {
        "collation": "SQL_Latin1_General_CP1_CI_AS",
        "maxSizeBytes": 214748364800,
        "sku": {
            "name": "GP_Gen5_4",
            "tier": "GeneralPurpose",
            "capacity": 4
        },
        "storageAccountType": "GRS",
        "zoneRedundant": false
    },
    "location": "eastus"
}
```

Refer to the exhibit. A DBA is creating an Azure SQL Managed Instance using the ARM template snippet shown. The DBA needs to ensure the instance can survive a regional outage without data loss. What change should be made to the template?

⚠ Common exam trap

A common mix-up: candidates confuse zone redundancy (which protects against datacenter failures within a region) with regional disaster recovery, and incorrectly assume that setting zoneRedundant to true is sufficient for surviving a regional outage, when in fact Azure SQL Managed Instance requires an auto-failover group with a secondary region for that purpose.

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

✓

Set zoneRedundant to true and configure an auto-failover group with a secondary region

Azure SQL Managed Instance does not natively support zone redundancy for regional outage protection; instead, it requires configuring an auto-failover group with a secondary instance in a paired region. Setting zoneRedundant to true alone only protects against zone failures within a single region, not a full regional outage. The auto-failover group ensures continuous replication and automatic failover to the secondary region, meeting the requirement of surviving a regional outage without data loss.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✗
Set collation to SQL_Latin1_General_CP1_CS_AS
Why it's wrong here
Collation change does not affect availability.
✗
Set zoneRedundant to true
Why it's wrong here
Zone redundancy protects against zonal failures, not regional outages.
✓
Set zoneRedundant to true and configure an auto-failover group with a secondary region
Why this is correct
Failover group with a secondary region provides regional disaster recovery.
✗
Change storageAccountType to RA-GRS
Why it's wrong here
Storage account type does not affect instance availability.

Go deeper

DP-300 Plan and implement data platform resources Practice Question

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question