nerdexam
Microsoft

AZ-305 · Question #178

You need to design a highly available Azure SQL database that meets the following requirements: - Failover between replicas of the database must occur without any data loss. - The database must…

The correct answer is A. Azure SQL Database Business Critical. To prevent Data Loss, Premium/Business Critical is required: The primary node constantly pushes changes to the secondary nodes in order and ensures that the data is persisted to at least one secondary replica before committing each transaction. This process guarantees that if…

Submitted by mateo_ar· Mar 6, 2026Design data storage solutions

Question

You need to design a highly available Azure SQL database that meets the following requirements: - Failover between replicas of the database must occur without any data loss. - The database must remain available in the event of a zone outage. - Costs must be minimized. Which deployment option should you use?

Options

  • AAzure SQL Database Business Critical
  • BAzure SQL Database Managed Instance Business Critical
  • CAzure SQL Database Hyperscale
  • DAzure SQL Database Standard

How the community answered

(42 responses)
  • A
    76% (32)
  • B
    14% (6)
  • C
    2% (1)
  • D
    7% (3)

Explanation

To prevent Data Loss, Premium/Business Critical is required: The primary node constantly pushes changes to the secondary nodes in order and ensures that the data is persisted to at least one secondary replica before committing each transaction. This process guarantees that if the primary node crashes for any reason, there is always a fully synchronized node to fail over to.

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full AZ-305 Practice