Medium1 markMultiple Choice
Domain 2.1: Relational Data StorageDatabasePostgreSQLHigh Availability

AZ-305 · Question 22 · Domain 2.1: Relational Data Storage

You are designing a high-availability architecture for an Azure Database for PostgreSQL Flexible Server.

The application requires zero data loss (RPO = 0) and automatic failover in the event of a datacenter outage within the primary Azure region. The solution must minimize failover time.

Which high availability configuration should you recommend?

Answer options:

A.

Same-zone High Availability

B.

Zone-redundant High Availability

C.

Geo-redundant backup

D.

Read replicas in a different region

How to approach this question

Match 'datacenter outage' to Availability Zones. Match 'RPO=0' to synchronous replication (Zone-redundant HA).

Full Answer

B.Zone-redundant High Availability✓ Correct
Azure Database for PostgreSQL Flexible Server supports Zone-redundant High Availability. This configuration provisions a primary server in one Availability Zone and a standby server in another. Data is synchronously replicated to the standby, ensuring zero data loss (RPO=0). If the primary zone goes down, it automatically fails over to the standby.

Common mistakes

Confusing Geo-redundancy (cross-region, asynchronous, RPO>0) with Zone-redundancy (cross-datacenter, synchronous, RPO=0).

Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 4

55 questions · hints · full answers · grading

More questions from this exam