Google Professional Cloud Database Engineer Question 178
Single answerGoogle Cloud PlatformYou are designing a multi-region database solution on Google Cloud for a global e-commerce application. The database must ensure high availability, low-latency reads for users in different regions, and data consistency in case of a regional failure. Which replication strategy should you use?
- A
Read replicas with asynchronous replication
- B
Multi-primary replication
- C
Single-primary replication with read replicas
- D
Spanner's synchronous replication using multi-region configuration
Show answer and explanation
Correct answer: D
Explanation
For a global e-commerce application requiring high availability, low-latency reads, and strong consistency in the event of a regional failure, Spanner's synchronous replication with a multi-region configuration is the best choice. It ensures that data is replicated across regions synchronously, providing strong consistency while maintaining low-latency access for users across the globe.
- A. Incorrect.
Read replicas with asynchronous replication provide low-latency reads but do not ensure strong consistency across regions, which is required in the scenario.
- B. Incorrect.
Multi-primary replication allows writes in multiple regions, but it introduces potential conflicts and is not ideal for scenarios requiring strong consistency.
- C. Incorrect.
Single-primary replication with read replicas offers strong consistency for writes but may increase latency for global users as all writes go to a single primary region.
- D. Correct.
Spanner's synchronous replication using multi-region configuration is designed for global applications, offering low-latency reads, high availability, and strong consistency by replicating data synchronously across multiple regions.