ExpertMedium1 markMultiple Choice
AZ-305 · Question 18 · Domain 2.1: Relational Data Storage
You are designing an architecture for a new web application that uses Azure Database for PostgreSQL - Flexible Server.
The application requires high availability with an SLA of 99.99%. In the event of an infrastructure failure, the database must fail over automatically with zero data loss (RPO = 0) and minimal downtime.
Which high availability configuration should you recommend?
You are designing an architecture for a new web application that uses Azure Database for PostgreSQL - Flexible Server.
The application requires high availability with an SLA of 99.99%. In the event of an infrastructure failure, the database must fail over automatically with zero data loss (RPO = 0) and minimal downtime.
Which high availability configuration should you recommend?
Answer options:
A.
Same-zone High Availability
B.
Zone-redundant High Availability
C.
Read Replicas
D.
Geo-redundant backup
How to approach this question
Identify the PostgreSQL Flexible Server HA option that uses synchronous replication across physical data centers.
Full Answer
B.Zone-redundant High Availability✓ Correct
Azure Database for PostgreSQL - Flexible Server offers Zone-redundant High Availability. This deploys a primary server in one Availability Zone and a standby server in another zone within the same region. It uses synchronous replication to the standby, ensuring zero data loss (RPO = 0). If the primary zone goes down, it automatically fails over to the standby zone.
Common mistakes
Confusing Read Replicas with HA. Read replicas are for read scale-out and cross-region DR, but they use asynchronous replication, meaning data loss can occur during a sudden failure.
Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 2
55 questions · hints · full answers · grading
More questions from this exam
Q01Fabrikam Inc. is a global financial services company with 200 Azure subscriptions managed via a c...HardQ02A healthcare organization has 500 on-premises Windows Server VMs and 300 Azure VMs. They are impl...HardQ03You are designing a security monitoring solution using Microsoft Sentinel.
The compliance depar...EasyQ04Your company has a microservices application deployed across multiple Azure App Service instances...MediumQ05A defense contractor is migrating to Microsoft 365 and Azure. They have a strict security policy ...Hard