Design a highly available Azure SQL deployment that meets these requirements: failover between replicas must be lossless, the database must remain available during a zone outage, and costs must be minimized. Which deployment option should you choose?

Azure SQL Database Premium is the correct choice because it offers zone-redundant high availability, ensuring the database remains available during a zone outage. It also provides synchronous replication for lossless failover, meeting the requirement for no data loss. While Business Critical offers similar features, Premium is generally more cost-effective for a single database, aligning with the cost minimization requirement. Azure SQL Database Basic does not offer zone redundancy or synchronous replication, making it unsuitable for high availability and lossless failover. Azure SQL Database Hyperscale offers high availability but its primary benefit is massive scalability, which isn't a stated requirement, and it can be more expensive than Premium for this specific scenario.