You have an Azure SQL database named DB1. You need to ensure that DB1 will support automatic failover without data loss if a datacenter fails. The solution must minimize costs. Which deployment…

The Azure SQL Database Premium (or Business Critical) service tier offers built-in high availability with zero data loss within a region and can be configured with active geo-replication or auto-failover groups to provide automatic failover and RPO 0 across datacenters, making it a cost-effective solution for this requirement compared to other advanced tiers.

The Basic tier of Azure SQL Database does not provide automatic failover with zero data loss across datacenters; its high availability model has a less robust SLA and higher Recovery Point Objective (RPO).

While Azure SQL Managed Instance General Purpose can support failover groups for cross-datacenter failover, a Managed Instance is generally more expensive per database than an Azure SQL Database single database for comparable workloads, and thus might not be the most cost-effective option unless other Managed Instance-specific features are required.

Azure SQL Database Hyperscale can achieve high availability and RPO 0 with multiple replicas, but it is a highly scalable and often more expensive tier designed for very large databases, which might not be the most cost-effective choice if its extensive scaling capabilities are not needed.