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 1Question 18
    Medium1 markMultiple Choice
    Domain 2.1: Design a data storage solution for relational dataDomain 2Relational DataPostgreSQLHigh Availability

    AZ-305 · Question 18 · Domain 2.1: Design a data storage solution for relational data

    A media company is building a global content management system using Azure Database for PostgreSQL - Flexible Server.

    The application has a heavy read-to-write ratio (90% reads, 10% writes). Users in Europe and Asia are experiencing high latency when reading data, as the primary database is located in East US. You need to improve read performance for global users while maintaining high availability for the primary database in East US.

    Which TWO features should you configure? (Select TWO)

    Answer options:

    A.

    Zone-redundant High Availability (HA)

    B.

    Cross-region Read Replicas

    C.

    Azure Cache for Redis

    D.

    Auto-failover groups

    E.

    Multi-region writes

    How to approach this question

    Address the two requirements: HA in the primary region (Zone-redundant HA) and low-latency reads globally (Cross-region Read Replicas).

    Full Answer

    Zone-redundant High Availability (HA) and Cross-region Read Replicas.
    To maintain high availability for the primary database in East US, you should enable Zone-redundant High Availability, which synchronously replicates data to a standby server in a different Availability Zone. To solve the read latency for users in Europe and Asia, you should deploy Cross-region Read Replicas. The application can direct read queries to the local replicas, while write queries continue to go to the primary server in East US.

    Common mistakes

    Selecting Multi-region writes, confusing PostgreSQL capabilities with Azure Cosmos DB capabilities.
    Question 17All questionsQuestion 19

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

    55 questions · hints · full answers · grading

    Sign up freeTake the exam

    More questions from this exam

    Q01Contoso Ltd is a global financial institution with 80 Azure subscriptions spread across 4 managem...MediumQ02Fabrikam Inc. operates a hybrid cloud environment with 500 on-premises VMware virtual machines ru...HardQ03A startup company has a single Azure subscription with a monthly budget of $5,000. The CFO want...EasyQ04You are designing an Azure Sentinel architecture for a Managed Security Service Provider (MSSP). ...MediumQ05A healthcare enterprise is migrating its infrastructure to Azure. They have strict compliance req...Hard
    View all 55 questions →