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.

    PracticeGCP Professional Cloud ArchitectGCP Professional Cloud Architect Practice Exam 7Question 38
    Hard1 markMultiple Choice
    Subtask 2.2: Storage SystemsCloud SQLHigh AvailabilityDisaster RecoveryDatabase

    GCP PCA · Question 38 · Storage Systems

    You are designing the database architecture for a mission-critical application using Cloud SQL for PostgreSQL. The application requires High Availability (HA) within the primary region to survive zone failures, and Disaster Recovery (DR) in a secondary region to survive a full region outage. Which TWO configurations must you implement? (Select TWO)

    Answer options:

    A.

    Enable the Regional High Availability (HA) configuration on the primary Cloud SQL instance.

    B.

    Configure synchronous replication to the secondary region.

    C.

    Use Cloud Spanner instead, as Cloud SQL cannot support cross-region DR.

    D.

    Create a cross-region read replica in the secondary region.

    E.

    Export daily SQL dumps to a multi-region Cloud Storage bucket.

    How to approach this question

    Identify the Cloud SQL feature for zonal HA (Regional configuration) and the feature for regional DR (Cross-region replica).

    Full Answer

    A,D
    To achieve High Availability (HA) in Cloud SQL, you enable the Regional HA configuration, which provisions a standby instance in a different zone and uses synchronous replication. To achieve Disaster Recovery (DR), you create a cross-region read replica. This replica receives data asynchronously. If the primary region goes down, you manually promote the cross-region replica to become the new primary.

    Common mistakes

    Assuming cross-region replication can be synchronous (Option B). The speed of light makes synchronous global replication impractical for standard relational databases.
    Question 37All questionsQuestion 39

    Practice the full GCP Professional Cloud Architect Practice Exam 7

    50 questions · hints · full answers · grading

    Sign up freeTake the exam

    More questions from this exam

    Q01CASE STUDY: TechStream Gaming Company Overview: TechStream Gaming is a global multiplayer game d...HardQ02CASE STUDY: TechStream Gaming Company Overview: TechStream Gaming is a global multiplayer game d...MediumQ03CASE STUDY: TechStream Gaming Company Overview: TechStream Gaming is a global multiplayer game d...MediumQ04CASE STUDY: TechStream Gaming Company Overview: TechStream Gaming is a global multiplayer game d...MediumQ05CASE STUDY: TechStream Gaming Company Overview: TechStream Gaming is a global multiplayer game d...Medium
    View all 50 questions →