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
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