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 4Question 40
    Medium1 markMultiple Choice
    Domain 2: Managing and Provisioning a Solution InfrastructureCloud SQLHigh AvailabilityRead Replicas

    GCP PCA · Question 40 · Domain 2: Managing and Provisioning a Solution Infrastructure

    You are provisioning a Cloud SQL for MySQL instance for a production application. The application requires high availability (HA) to survive a zone failure, and needs to support heavy read traffic from reporting dashboards without impacting the primary transactional workload. Which TWO configurations should you enable? (Select TWO)

    Answer options:

    A.

    Enable Regional High Availability (HA) to create a standby instance in a different zone.

    B.

    Configure a multi-region Cloud Spanner instance.

    C.

    Create a Read Replica and point the reporting dashboards to it.

    D.

    Enable automated backups and point the reporting dashboards to the backup bucket.

    E.

    Increase the vCPU and RAM of the primary instance to handle both workloads.

    How to approach this question

    Address the two requirements separately: HA for zone failures, and offloading read traffic.

    Full Answer

    To survive a zone failure in Cloud SQL, you must enable Regional High Availability (Option A), which creates a synchronous standby instance in another zone. To prevent heavy reporting queries from impacting the primary transactional database, you should provision a Read Replica (Option C) and route the dashboard traffic to it.

    Common mistakes

    Assuming HA instances can be used for read scaling. The HA standby instance in Cloud SQL is passive and cannot serve read queries.
    Question 39All questionsQuestion 41

    Practice the full GCP Professional Cloud Architect Practice Exam 4

    50 questions · hints · full answers · grading

    Sign up freeTake the exam

    More questions from this exam

    Q01CASE STUDY: TechStream Gaming Overview: 500 employees, $100M revenue. On-prem US/EU, 200 servers...MediumQ02CASE STUDY: TechStream Gaming Overview: 500 employees, $100M revenue. On-prem US/EU, 200 servers...MediumQ03CASE STUDY: TechStream Gaming Overview: 500 employees, $100M revenue. On-prem US/EU, 200 servers...HardQ04CASE STUDY: TechStream Gaming Overview: 500 employees, $100M revenue. On-prem US/EU, 200 servers...HardQ05CASE STUDY: TechStream Gaming Overview: 500 employees, $100M revenue. On-prem US/EU, 200 servers...Easy
    View all 50 questions →