Plan and configure a high availability and disaster recovery environment →hardMultiple Choice

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
A high-availability replica is provided by the Business Critical tier, not General Purpose, which relies on remote storage; the exhibit shows General Purpose. The statement tempts because Business Critical does include such a replica, but that tier is not configured here.
✗
The configuration is invalid because General Purpose tier cannot be zone-redundant.
Why it's wrong here
General Purpose supports zone-redundant configuration in supported regions, so the configuration is valid; the claim of invalidity is false. It tempts because zone redundancy was historically limited to Business Critical, but that restriction no longer applies.
✗
The database uses locally-redundant backup storage.
Why it's wrong here
Locally-redundant storage keeps three copies within one datacentre; the exhibit's backup storage redundancy value determines this, and it specifies zone-redundant instead. LRS tempts as the default cheap option, but the configuration shown does not select it.
✓
The database is in General Purpose tier and supports zone redundancy.
Why this is correct
The General Purpose service tier supports zone redundancy when the configuration enables it, which the exhibit's properties confirm. This distinguishes it from Business Critical, which also offers zone redundancy, and from Basic or Standard tiers, which do not support it.

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