Answer-first summary for fast verification
Answer: Set up read replicas to distribute read traffic
The correct answer is **C** because read replicas are designed to handle read traffic, thereby reducing the load on the primary database. This approach is scalable and efficient for read-heavy applications. - **Option A** is incorrect as backups are intended for disaster recovery, not for scaling read operations. - **Option B** is incorrect because high availability configurations are aimed at ensuring failover capabilities, not improving read performance. - **Option D** is incorrect due to the complexity and maintenance overhead associated with managing external replicas, making it less ideal for scaling purposes. For more details, refer to the GCP documentation on [Cloud SQL Replication Options](https://cloud.google.com/sql/docs/replication).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
An application utilizing Cloud SQL for accessing infrequently changing data is expected to experience significant growth. What strategy can be employed to enhance capacity for additional read-only clients?
A
Utilize backups to enable restoration in the event of an outage
B
Configure high availability on the master node
C
Set up read replicas to distribute read traffic
D
Establish an external replica within the customer's data center
No comments yet.