Google Professional Cloud Database Engineer Question 253
Select 3Google Cloud PlatformYour organization is running a global e-commerce platform hosted on Google Cloud. The platform uses a Cloud SQL for PostgreSQL instance as its primary database. Recently, you have noticed an increase in read queries due to high traffic during promotional sales, leading to performance bottlenecks. To address this, you decide to implement read replicas. Which of the following factors should you consider when assessing the requirements for read replicas?
- A
The read replica will automatically handle all write operations to improve performance.
- B
The read replica introduces additional replication latency, which may impact real-time read consistency.
- C
The primary instance must have sufficient resources to handle replication traffic.
- D
Read replica data remains consistent with the primary instance without any delay.
- E
Read replicas can be used to distribute read traffic across multiple regions for better performance.
Show answer and explanation
Correct answers: B, C, E
Explanation
When assessing the requirements for read replicas, it is important to account for factors like replication latency, the resource impact on the primary instance, and the ability to distribute read traffic for performance improvements. However, read replicas cannot handle write operations, and their data is not guaranteed to be fully consistent with the primary due to replication delays.
- A. Incorrect.
Incorrect: Read replicas are designed only for read operations. Write operations must always go to the primary instance.
- B. Correct.
Correct: Replication between the primary instance and read replicas introduces some latency, meaning there could be a delay in the read replica reflecting the latest changes.
- C. Correct.
Correct: The replication process requires the primary instance to handle additional traffic, so it's crucial to ensure the primary has enough resources to maintain performance.
- D. Incorrect.
Incorrect: Due to replication latency, read replicas might not always have the most up-to-date data. There is no guarantee of real-time consistency.
- E. Correct.
Correct: Read replicas can be configured in different regions, enabling you to distribute read workloads closer to users and improve performance.