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 1Question 30
    Medium1 markMultiple Choice
    Subtask 3.1: Security DesignDatabaseCloud SQLRead ReplicasPerformance

    GCP PCA · Question 30 · Security Design

    Your e-commerce application uses Cloud SQL for PostgreSQL. During peak shopping hours, the database CPU hits 95% due to a massive number of read queries from the product catalog, causing latency. Write operations (orders) remain low. How should you optimize the database architecture?

    Answer options:

    A.

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

    B.

    Create a Cloud SQL Read Replica and update the application to send read queries to the replica.

    C.

    Migrate the database to Cloud Spanner.

    D.

    Increase the storage capacity of the Cloud SQL instance to increase IOPS.

    How to approach this question

    Identify the feature used to scale read-heavy workloads in relational databases.

    Full Answer

    B.Create a Cloud SQL Read Replica and update the application to send read queries to the replica.✓ Correct
    Cloud SQL Read Replicas are designed specifically to scale out read-heavy workloads. The primary instance replicates data asynchronously to the read replica. You then update your application logic to route read queries (like browsing the product catalog) to the replica, freeing up the primary instance's CPU to handle write queries (like placing orders).

    Common mistakes

    Confusing High Availability (HA) with Read Replicas. HA is for disaster recovery (active-passive), while Read Replicas are for performance scaling (active-active for reads).
    Question 29All questionsQuestion 31

    Practice the full GCP Professional Cloud Architect Practice Exam 1

    50 questions · hints · full answers · grading

    Sign up freeTake the exam

    More questions from this exam

    Q01**CASE STUDY: TechStream Gaming** **Company Overview:** TechStream Gaming is a global gaming com...HardQ02**CASE STUDY: TechStream Gaming** **Company Overview:** TechStream Gaming is a global gaming com...MediumQ03**CASE STUDY: TechStream Gaming** **Company Overview:** TechStream Gaming is a global gaming com...HardQ04**CASE STUDY: TechStream Gaming** **Company Overview:** TechStream Gaming is a global gaming com...MediumQ05**CASE STUDY: TechStream Gaming** **Company Overview:** TechStream Gaming is a global gaming com...Medium
    View all 50 questions →