DP-300 Plan and configure a high availability and disaster recovery environment — All Questions With Answers

Refer to the exhibit.

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

Refer to the exhibit.

```
{
  "sku": {
    "name": "BusinessCritical",
    "tier": "BusinessCritical",
    "family": "Gen5",
    "capacity": 8
  },
  "properties": {
    "zoneRedundant": true,
    "highAvailabilityReplicaCount": 2,
    "readScale": "Enabled"
  }
}
```

Refer to the exhibit.

```
{
  "properties": {
    "readScale": "Enabled",
    "zoneRedundant": false,
    "highAvailabilityReplicaCount": 4,
    "requestedServiceObjectiveName": "BC_Gen5_8"
  }
}
```

{
  "properties": {
    "readScale": {
      "type": "Boolean",
      "value": "Enabled"
    },
    "zoneRedundant": {
      "type": "Boolean",
      "value": "true"
    },
    "highAvailabilityReplicaCount": {
      "type": "Integer",
      "value": 2
    }
  }
}

{
  "properties": {
    "partnerServers": [
      {
        "id": "/subscriptions/.../resourceGroups/rg2/providers/Microsoft.Sql/managedInstances/mi2",
        "location": "westus",
        "replicationRole": "Secondary"
      }
    ],
    "readWriteEndpoint": {
      "failoverPolicy": "Automatic",
      "failoverWithDataLossGracePeriodMinutes": 60
    },
    "readOnlyEndpoint": {
      "failoverPolicy": "Disabled"
    }
  }
}

Refer to the exhibit.

```json
{
  "properties": {
    "databases": ["/subscriptions/.../databases/db1"],
    "partnerServers": [
      {
        "id": "/subscriptions/.../servers/secondary",
        "location": "westeurope"
      }
    ],
    "readWriteEndpoint": {
      "failoverPolicy": "Automatic",
      "failoverGracePeriodMinutes": 60
    },
    "readOnlyEndpoint": {
      "failoverPolicy": "Disabled"
    }
  }
}
```

Refer to the exhibit.

```json
{
  "properties": {
    "replicationRole": "Secondary",
    "replicationState": "CATCH_UP",
    "replicationLag": "00:00:05"
  }
}
```

Refer to the exhibit.

```powershell
Get-AzSqlDatabaseGeoBackup -ResourceGroupName "rg1" -ServerName "sqlserver1" -DatabaseName "db1" | Restore-AzSqlDatabase -FromGeoBackup -TargetResourceGroupName "rg2" -TargetServerName "sqlserver2" -TargetDatabaseName "db1-restored"
```

Refer to the exhibit. The following is a snippet of an Azure Policy definition for auditing SQL Server disaster recovery configuration:

{
  "policyRule": {
    "if": {
      "allOf": [
        {
          "field": "type",
          "equals": "Microsoft.Sql/servers"
        },
        {
          "field": "Microsoft.Sql/servers/version",
          "equals": "12.0"
        },
        {
          "anyOf": [
            {
              "field": "Microsoft.Sql/servers/encryptionProtector/serverKeyName",
              "exists": "false"
            },
            {
              "field": "Microsoft.Sql/servers/encryptionProtector/serverKeyName",
              "equals": "ServiceManaged"
            }
          ]
        }
      ]
    },
    "then": {
      "effect": "audit"
    }
  }
}

Refer to the exhibit. The following is a snippet of an Azure CLI script used to configure geo-replication:

az sql db replica create \
  --resource-group myRG \
  --server primaryServer \
  --name myDB \
  --partner-server secondaryServer \
  --secondary-type Geo \
  --family Gen5 \
  --capacity 2

Refer to the exhibit. The following is a Kusto query from Azure Monitor analyzing failover events:

AzureDiagnostics
| where ResourceProvider == "MICROSOFT.SQL"
| where Category == "DatabaseWaitStatistics"
| where wait_type == "FAILOVER_GROUP_WAIT"
| summarize TotalWait = sum(wait_time_ms) by DatabaseName, bin(TimeGenerated, 1h)
| where TotalWait > 100000
| project DatabaseName, TimeGenerated, TotalWait

{
  "properties": {
    "databases": [
      "/subscriptions/.../databases/OrdersDB"
    ],
    "partnerServers": [
      {
        "id": "/subscriptions/.../servers/secondary-server",
        "location": "westus"
      }
    ],
    "readWriteEndpoint": {
      "failoverPolicy": "Automatic",
      "failoverGracePeriodMinutes": 60
    },
    "readOnlyEndpoint": {
      "failoverPolicy": "Disabled"
    }
  },
  "type": "Microsoft.Sql/servers/failoverGroups"
}

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

{
  "properties": {
    "partnerRegions": [
      {
        "location": "westus",
        "replicationRole": "Secondary"
      }
    ],
    "instanceFailoverGroupReadWriteEndpoint": {
      "failoverPolicy": "Automatic",
      "failoverGracePeriodMinutes": 60
    },
    "secondaryType": "Geo",
    "zoneRedundant": false
  },
  "type": "Microsoft.Sql/locations/instanceFailoverGroups"
}

{
  "type": "Microsoft.Sql/servers/databases",
  "apiVersion": "2023-08-01-preview",
  "properties": {
    "requestedBackupStorageRedundancy": "Geo",
    "createMode": "PointInTimeRestore",
    "sourceDatabaseId": "/subscriptions/.../resourceGroups/rg1/providers/Microsoft.Sql/servers/server1/databases/db1",
    "restorePointInTime": "2025-02-15T03:00:00Z"
  }
}

{
  "properties": {
    "databases": [
      {
        "name": "SalesDB",
        "readScale": "Enabled",
        "readReplicaCount": 2
      }
    ]
  }
}

Refer to the exhibit.
{
  "properties": {
    "partnerServers": [
      {
        "id": "/subscriptions/.../resourceGroups/rg1/providers/Microsoft.Sql/servers/server2"
      }
    ],
    "readWriteEndpoint": {
      "failoverPolicy": "Automatic",
      "failoverGracePeriod": 60
    },
    "readOnlyEndpoint": {
      "failoverPolicy": "Disabled"
    },
    "databases": [
      "/subscriptions/.../resourceGroups/rg1/providers/Microsoft.Sql/servers/server1/databases/db1"
    ]
  }
}

{
  "type": "Microsoft.Sql/servers/databases/backupShortTermRetentionPolicies",
  "apiVersion": "2023-08-01-preview",
  "properties": {
    "retentionDays": 14,
    "diffBackupIntervalInHours": 12
  }
}