AZ-305 Practice Question 77: PostgreSQL Flexible Server Zone Redundant HA
Microsoft Azure Solutions Architect Expert (AZ-305) · Test 8 · question 7 of 10
A company is migrating an application to Azure Database for PostgreSQL Flexible Server. The design must survive the loss of an entire availability zone with automatic failover and zero data loss, and the region the application is deployed to supports availability zones. Which configuration should the architect choose?
Show answer and explanation
Answer:
Zone-redundant high availability for Flexible Server places a standby replica in a different availability zone from the primary, replicates data changes to it synchronously so there is zero data loss on failover, and triggers automatic failover typically within 60 to 120 seconds if the primary or its zone becomes unavailable. This directly satisfies the zone-failure and zero-data-loss requirement.
Same-zone high availability protects against a failure of the compute or storage node but keeps the standby in the same availability zone as the primary, so it does not protect against the loss of an entire zone. Read replicas use asynchronous replication, so committed transactions can be lost on failover, and promoting a read replica is a manual operation, not automatic failover. The Burstable compute tier is a cost-oriented sizing choice for light, intermittent workloads and Defender for PostgreSQL is a threat detection capability; neither provides zone-level high availability.
Reference: High availability in Azure Database for PostgreSQL flexible server