ExpertMinds LogoExpertMinds
Hard1 markMultiple Choice
Domain 2.1: Relational Data StorageDomain 2Data StoragePostgreSQLHigh Availability

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:

A.

Azure Database for PostgreSQL - Single Server with Geo-redundant backup

B.

Azure Database for PostgreSQL - Flexible Server with Same-zone High Availability

C.

Azure Database for PostgreSQL - Flexible Server with Zone-redundant High Availability

D.

PostgreSQL on Azure VMs with asynchronous replication

How to approach this question

Match 'datacenter failure' to 'Availability Zone'. Match 'synchronous replication/automatic failover' to 'Zone-redundant HA' in Flexible Server.

Full Answer

C.Azure Database for PostgreSQL - Flexible Server with Zone-redundant High Availability✓ Correct
Azure Database for PostgreSQL - Flexible Server offers a 'Zone-redundant High Availability' configuration. This deploys a primary server in one Availability Zone and a standby server in a different Availability Zone within the same region. Data is synchronously replicated to the standby, ensuring zero data loss (RPO = 0). If the primary zone fails, the service automatically fails over to the standby server.

Common mistakes

Choosing Same-zone HA, which does not protect against a full datacenter (zone) outage.
18All questions20

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

55 questions · hints · full answers · grading

Sign up freeTake the exam

More questions from this exam

Q01Contoso Ltd has 50 subscriptions across 3 business units. Each business unit manages its own IT o...EasyQ02You are designing a monitoring solution for a hybrid environment. The environment consists of 200...MediumQ03Your company uses Microsoft Sentinel integrated with a Log Analytics workspace. The workspace ing...HardQ04You are designing an application monitoring strategy using Application Insights. The application ...MediumQ05A highly regulated financial institution is migrating to Microsoft 365 and Azure. They currently ...Hard
View all 55 questions →