AZ-305 · Question 19 · Domain 2.1: Relational Data Storage
You are designing the architecture for an open-source application that requires a PostgreSQL database.
The application will be deployed in the 'East US' region. You must ensure the database remains available even if an entire datacenter (Availability Zone) within the region goes offline. The solution must provide synchronous replication to ensure zero data loss (RPO = 0) during a zone failure, and automatic failover.
Which Azure database service and configuration should you recommend?
Answer options:
Azure Database for PostgreSQL - Single Server with Geo-redundant backup
Azure Database for PostgreSQL - Flexible Server with Same-zone High Availability
Azure Database for PostgreSQL - Flexible Server with Zone-redundant High Availability
PostgreSQL on Azure VMs with asynchronous replication
55 questions · hints · full answers · grading