nerdexam
Microsoft

DP-300 · Question #17

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…

The correct answer is B. No. Instead deploy an Azure SQL database that uses the Business Critical service tier and Availability Note: Premium and Business Critical service tiers leverage the Premium availability model, which integrates compute resources (sqlservr.exe process) and storage (locally attached…

Submitted by salim_om· Mar 6, 2026Plan and configure a high availability and disaster recovery environment

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 General Purpose service tier and failover groups. Does this meet the goal?

Options

  • AYes
  • BNo

How the community answered

(58 responses)
  • A
    19% (11)
  • B
    81% (47)

Explanation

Instead deploy an Azure SQL database that uses the Business Critical service tier and Availability Note: Premium and Business Critical service tiers leverage the Premium availability model, which integrates compute resources (sqlservr.exe process) and storage (locally attached SSD) on a High availability is achieved by replicating both compute and storage to additional nodes creating a three to four-node cluster. By default, the cluster of nodes for the premium availability model is created in the same datacenter. With the introduction of Azure Availability Zones, SQL Database can place different replicas of the Business Critical database to different availability zones in the same region. To eliminate a single point of failure, the control ring is also duplicated across multiple zones as three gateway rings (GW). https://docs.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-300 Practice