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 Premium. Azure SQL Database Premium tier supports multiple redundant replicas for each database that are automatically provisioned in the same datacenter within a region. This design leverages the SQL Server AlwaysON technology and provides resilience to server failures with 99.99%…

Submitted by suresh_in· 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 Premium
BAzure SQL Database Hyperscale
CAzure SQL Database Basic
DAzure SQL Managed Instance Business Critical

How the community answered

(55 responses)

A
71% (39)
B
4% (2)
C
9% (5)
D
16% (9)

Explanation

Azure SQL Database Premium tier supports multiple redundant replicas for each database that are automatically provisioned in the same datacenter within a region. This design leverages the SQL Server AlwaysON technology and provides resilience to server failures with 99.99% availability SLA and RPO=0. With the introduction of Azure Availability Zones, we are happy to announce that SQL Database now offers built-in support of Availability Zones in its Premium service tier. https://azure.microsoft.com/en-us/blog/azure-sql-database-now-offers-zone-redundant-premium- databases-and-elastic-pools/

Community Discussion

No community discussion yet for this question.

Full AZ-305 Practice