Google Professional Cloud Database Engineer Question 251
Select 4Google Cloud PlatformYou are managing a Cloud SQL instance for an e-commerce application that experiences high read traffic during seasonal sales. The application users report increased latency during these peak times. You need to assess the requirements for adding read replicas to improve performance. Which of the following factors should you consider before implementing read replicas?
- A
The current read-to-write ratio of your workload
- B
The network latency between the primary instance and potential read replicas
- C
The geographical location of your application's users
- D
Whether the database supports automatic failover to read replicas in case of primary instance failure
- E
The compatibility of the database engine with read replicas
Show answer and explanation
Correct answers: A, B, C, E
Explanation
When assessing requirements for read replicas, you must evaluate the workload's read-to-write ratio, network latency for replication, the geographical proximity of replicas to users, and database engine compatibility. These factors directly impact the effectiveness of read replicas in improving performance. Failover capabilities are unrelated to read replicas and should not be considered in this context.
- A. Correct.
Understanding the read-to-write ratio is critical because read replicas are designed to handle read-heavy workloads. If your workload is write-heavy, read replicas may not provide significant benefits.
- B. Correct.
Network latency between the primary instance and read replicas can impact the performance and consistency of data replication, so it must be considered.
- C. Correct.
Geographical location matters as deploying read replicas closer to users can reduce latency for read operations, improving performance.
- D. Incorrect.
Read replicas are not intended for automatic failover; they are designed to improve read performance. You would need a separate high-availability setup for failover.
- E. Correct.
Not all database engines support read replicas, so verifying compatibility is essential before implementation.