Answer-first summary for fast verification
Answer: Create a read replica to handle read operations.
The optimal first step is to create a read replica for read operations, as it requires minimal changes to database applications. While caching with Cloud Memorystore could improve performance, it necessitates application modifications. Similarly, setting up a secondary database or optimizing queries would also require changes to the application. For more details, refer to [Google Cloud SQL documentation](https://cloud.google.com/sql/docs/mysql/replication).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You're a database administrator noticing that a Cloud SQL database with PostgreSQL isn't meeting its read operation SLAs. Your goal is to enhance read performance with minimal application changes. Which strategy should you consider first?
A
Utilize Cloud Memorystore to cache data intended for reading.
B
Implement change data capture to synchronize a secondary database in another region with the primary, directing read operations to the secondary.
C
Create a read replica to handle read operations.
D
Analyze and optimize queries using PostgreSQL's explain plan feature.
No comments yet.