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

{
  "properties": {
    "backupStorageRedundancy": "Geo",
    "geoBackupPolicy": {
      "state": "Enabled",
      "location": "eastus2",
      "retentionDays": 7
    },
    "longTermRetentionPolicy": {
      "weeklyRetention": "P4W",
      "monthlyRetention": "P12M",
      "yearlyRetention": "P3Y"
    }
  },
  "type": "Microsoft.Sql/servers/databases/backupLongTermRetentionPolicies"
}

Refer to the exhibit. You are configuring a backup policy for an Azure SQL Database. The database is in the East US region. You need to ensure that the database can be restored to a different region in the event of a regional disaster. Which setting in the exhibit must be correctly configured?

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 backupStorageRedundancy is set to Geo.

BackupStorageRedundancy must be set to 'Geo' to enable geo-redundant backups that can be restored to a different region in case of a regional disaster. Option A is incorrect because the geoBackupPolicy state being Enabled simply enables the geo-backup policy, but it does not ensure geo-redundancy if the storage redundancy is not set to Geo. Option B is incorrect because the geoBackupPolicy location indicates where the geo-backup is stored, but the key setting for cross-region restore is the storage redundancy, not the location. Option D is incorrect because weeklyRetention defines how long weekly backups are retained, which does not affect the ability to restore to a different region.

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 geoBackupPolicy state is Enabled.
Why it's wrong here
This policy may be enabled but without geo-redundant storage, cross-region restore is not possible.
✗
The geoBackupPolicy location is set to eastus2.
Why it's wrong here
The location indicates where the backup is stored, but the storage redundancy is the critical factor.
✓
The backupStorageRedundancy is set to Geo.
Why this is correct
Geo-redundant backups are required for geo-restore.
✗
The weeklyRetention is set to P4W.
Why it's wrong here
Retention settings do not affect cross-region restore capability.

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