You are deploying Azure Database for PostgreSQL for an e-commerce platform in a region with multiple availability zones. The solution must provide automatic failover with zero data loss within the region and support read-only analytics in another region without impacting OLTP performance. What should you implement?
Choose an answer
Tap an option to check your answer.
Correct answer: Azure Database for PostgreSQL Flexible Server with zone-redundant high availability enabled; create cross-region read replicas for analytics.
Why this is the answer
The correct option is Azure Database for PostgreSQL Flexible Server with zone-redundant high availability enabled; create cross-region read replicas for analytics. Flexible Server with zone-redundant high availability provides automatic failover within the region with zero data loss by maintaining a synchronous standby replica in a different availability zone. Cross-region read replicas allow for read-only analytics in another region without impacting the primary OLTP workload. Azure Database for PostgreSQL Single Server with geo-redundant backups only does not offer automatic failover or zero data loss; restoration is a manual process. Azure SQL Database Hyperscale is a different database service and not PostgreSQL. Azure Database for PostgreSQL Flexible Server in a single zone does not provide zone-redundant high availability. PostgreSQL on Azure VMs with manual log shipping is a self-managed solution that requires significant administrative overhead and does not offer the automatic failover or zero data loss guarantees of Flexible Server.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed