For IndividualsFor Educators
ExpertMinds LogoExpertMinds
ExpertMinds

Ace your certifications with Practice Exams and AI assistance.

  • Browse Exams
  • For Educators
  • Blog
  • Privacy Policy
  • Terms of Service
  • Cookie Policy
  • Support
  • AWS SAA Exam Prep
  • PMI PMP Exam Prep
  • CPA Exam Prep
  • GCP PCA Exam Prep

© 2026 TinyHive Labs. Company number 16262776.

    PracticeAzure Solutions Architect Expert (AZ-305)Azure Solutions Architect Expert AZ-305 Practice Exam 5Question 19
    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 with Zone-redundant High Availability
    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.
    Question 18All questionsQuestion 20

    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 →