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:
Enable High Availability (HA) on the Cloud SQL instance.
Create a Cloud SQL Read Replica and update the application to send read queries to the replica.
Migrate the database to Cloud Spanner.
Increase the storage capacity of the Cloud SQL instance to increase IOPS.
50 questions · hints · full answers · grading