DP-300 Certification Practice Question #256

Question

SIMULATION
 -

You need to configure high availability for db1. The solution must tolerate the loss of an Azure datacenter without data loss or the need to modify application connection strings.

To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.

Accepted Answer

To tolerate the loss of an entire Azure datacenter (which corresponds to an Availability Zone failure) with zero data loss (RPO = 0) and no connection string changes:
1. If `db1` is an Azure SQL Database, we enable **Zone Redundancy** (which requires Premium, Business Critical, or Hyperscale service tiers). This replicates the database synchronously across different availability zones/datacenters in the same region, maintaining the same connection string.
2. If `db1` is a database on SQL Server on Azure VM, we deploy an **Always On Availability Group** across VMs in different Availability Zones within the same region, set to **Synchronous Commit** mode with an **Availability Group Listener** configured.

More DP-300 practice questions