Design a highly available Azure SQL database deployment that meets the following: failover between replicas must occur without any data loss, the database must remain available during a zone outage, and costs should be minimized. Which deployment option should you select?
Choose an answer
Tap an option to check your answer.
Correct answer: Azure SQL Database Premium.
Why this is the answer
Azure SQL Database Premium (or Business Critical) tier offers zone-redundant high availability, ensuring no data loss during failover and continued availability during a zone outage. This tier uses Always On Availability Groups with multiple synchronous replicas across availability zones. Azure SQL Database Hyperscale also offers zone redundancy but is typically more expensive and designed for very large databases, exceeding the "cost minimized" requirement for many scenarios. Azure SQL Database Basic does not offer zone redundancy or guaranteed zero data loss on failover. Azure SQL Managed Instance General Purpose offers high availability within a single availability zone but not across zones, meaning it wouldn't survive a zone outage.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed