Plan and configure a high availability and disaster recovery environment →hardMultiple ChoiceObjective-mapped

DP-300 Practice Question: Plan and configure a high availability and disaster recovery environment

Exhibit

Refer to the exhibit.

{
  "properties": {
    "readScale": "Enabled",
    "requestedServiceObjectiveName": "GP_Gen5_2",
    "zoneRedundant": true,
    "highAvailabilityReplicaCount": 0,
    "backupStorageRedundancy": "Geo",
    "minCapacity": 0.5
  }
}

You are reviewing a JSON configuration for an Azure SQL Database. The exhibit shows the database properties. Which statement about this database is correct?

⚠ Common exam trap

Candidates may incorrectly assume that zone redundancy is only for Business Critical, but Azure now supports it for General Purpose (vCore) in many regions.

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

✓

The database is in General Purpose tier and supports zone redundancy.

The JSON configuration shows zoneRedundant set to true and the service tier is General Purpose. As of current Azure SQL Database documentation, zone redundancy is supported for the General Purpose tier (vCore purchasing model) in many regions. Therefore, the configuration is valid. Option D correctly states that the database is in General Purpose tier and supports zone redundancy. Option A is incorrect because highAvailabilityReplicaCount is 0, not 1. Option B is incorrect because zone redundancy is available for General Purpose. Option C is incorrect because backupStorageRedundancy is Geo (geo-redundant), not locally-redundant.

Answer analysis

Option-by-option breakdown

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

✗
The database has one high-availability replica.
Why it's wrong here
HighAvailabilityReplicaCount is 0, so the database does not have one high-availability replica.
✗
The configuration is invalid because General Purpose tier cannot be zone-redundant.
Why it's wrong here
Zone redundancy is now supported for General Purpose tier (vCore), so this configuration is not invalid.
✗
The database uses locally-redundant backup storage.
Why it's wrong here
BackupStorageRedundancy is Geo, meaning geo-redundant backup storage, not locally-redundant.
✓
The database is in General Purpose tier and supports zone redundancy.
Why this is correct
The database is in General Purpose tier and zoneRedundant is true, which is a valid configuration as zone redundancy is supported for General Purpose.

Go deeper

DP-300 Practice Question: Plan and configure a high availability and disaster recovery environment

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question