Exam AZ-305 topic 4 question 84 discussion

Zone-redundancy is currently in public preview for the General Purpose service tier (2024-07) - so you are right, but I don't think the exams rely on public previews, only on public available features: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/instance-zone-redundancy-configure

Azure SQL DB Standard tier only supports LRS. https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell#basic-standard-and-general-purpose-service-tier-locally-redundant-availability

https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell#premium-and-business-critical-service-tier-zone-redundant-availability By default, the cluster of nodes for the premium availability model is created in the same datacenter. With the introduction of Azure Availability Zones, SQL Database can place different replicas of the Business Critical database to different availability zones in the same region. To eliminate a single point of failure, the control ring is also duplicated across multiple zones as three gateway rings (GW). The routing to a specific gateway ring is controlled by Azure Traffic Manager (ATM). Because the zone-redundant configuration in the Premium or Business Critical service tiers doesn't create additional database redundancy, you can enable it at no extra cost. By selecting a zone-redundant configuration, you can make your Premium or Business Critical databases resilient to a much larger set of failures, including catastrophic datacenter outages, without any changes to the application logic.