Medium1 markMultiple Choice
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?
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
Create a Cloud SQL Read Replica and update the application to send read queries to the replica.
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).
Practice the full GCP Professional Cloud Architect Practice Exam 1
50 questions · hints · full answers · grading
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
Expert