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 2Question 18
    Medium1 markMultiple Choice
    Domain 2.1: Relational Data StorageDomain 2PostgreSQLHigh AvailabilityFlexible Server

    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?

    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
    Zone-redundant High Availability
    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.
    Question 17All questionsQuestion 19

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

    55 questions · hints · full answers · grading

    Sign up freeTake the exam

    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
    View all 55 questions →