Design a highly available Azure SQL database that fails over between replicas with no data loss, remains available during a zone outage, and minimizes cost. Which deployment option should you choose?

Azure SQL Database—Premium tier offers zone-redundant high availability, ensuring no data loss and continuous availability during zone outages. This tier uses multiple synchronous replicas across availability zones, meeting the no data loss and zone outage requirements. While Business Critical tiers (for both Managed Instance and Database) also offer zone redundancy and no data loss, the Premium tier for Azure SQL Database is generally more cost-effective than Azure SQL Managed Instance—Business Critical, which is designed for lift-and-shift scenarios requiring near 100% feature compatibility with SQL Server. Azure SQL Database—Basic lacks zone redundancy and synchronous replicas, making it unsuitable for high availability and no data loss requirements. Azure SQL Managed Instance—General Purpose also lacks zone redundancy for its primary replica, making it vulnerable to zone outages.