DP-300 Certification Practice Question #219

Question

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an Azure SQL database named Sales.
You need to implement disaster recovery for Sales to meet the following requirements:
✑ During normal operations, provide at least two readable copies of Sales.
✑ Ensure that Sales remains available if a datacenter fails.
Solution: You deploy an Azure SQL database that uses the Business Critical service tier and Availability Zones.
Does this meet the goal?

Accepted Answer

The proposed solution meets all requirements. First, the Business Critical service tier features built-in high availability using a cluster of replicas, and it supports **Read Scale-Out** at no additional cost. This allows read-only connections to be routed to a secondary replica while write connections go to the primary, resulting in at least two readable copies of the database during normal operations. Second, enabling **Availability Zones** ensures that the replicas are distributed across separate physical zones (datacenters) within the region, providing zero-data-loss automatic failover if a datacenter fails.

More DP-300 practice questions