Google Professional Cloud Database Engineer Question 177
Select 2Google Cloud PlatformYou are designing a replication strategy for a Cloud SQL PostgreSQL database to ensure high availability and disaster recovery. The application requires a low Recovery Point Objective (RPO) and Recovery Time Objective (RTO). Additionally, the solution should minimize latency for read-heavy workloads across geographically distributed regions. Which replication strategies should you implement?
- A
Use a read replica in a different region with asynchronous replication.
- B
Configure a failover replica in the same region with synchronous replication.
- C
Use a read replica in the same region with synchronous replication.
- D
Implement a cross-region read replica with synchronous replication.
- E
Set up a cross-region failover replica with asynchronous replication.
Show answer and explanation
Correct answers: A, B
Explanation
For high availability with low RPO and RTO, a failover replica in the same region with synchronous replication is essential. To minimize latency for read-heavy workloads across different regions, using an asynchronous read replica in a different region is the best approach. Cross-region failover replicas with asynchronous replication or synchronous replication are either unsupported or do not meet the requirements of the use case.
- A. Correct.
Correct. A read replica in a different region with asynchronous replication helps distribute read-heavy workloads while minimizing latency for geographically distributed users. However, since it's asynchronous, there may be a slight delay in updates.
- B. Correct.
Correct. A failover replica in the same region with synchronous replication ensures high availability with minimal data loss (low RPO) and fast recovery (low RTO) in case of primary instance failure.
- C. Incorrect.
Incorrect. A read replica in the same region with synchronous replication is not an ideal choice for geographically distributed workloads and does not meet the disaster recovery requirements.
- D. Incorrect.
Incorrect. Cross-region synchronous replication is not supported in Cloud SQL as synchronous replication requires low-latency connections that are difficult to achieve across regions.
- E. Incorrect.
Incorrect. A cross-region failover replica with asynchronous replication may help with disaster recovery but does not support low RPO or RTO due to potential data lag.