Google Professional Cloud Database Engineer Question 30
Single answerGoogle Cloud PlatformYou are designing a database deployment strategy for a global e-commerce platform. The platform must provide high availability, low latency for users across multiple continents, and disaster recovery capabilities. However, the company is sensitive to cost and wants an optimized solution without overengineering. Which deployment strategy should you choose?
- A
A multi-region database deployment with read-write instances in each region.
- B
A regional database deployment with a zonal failover replica within the same region.
- C
A multi-region database deployment with a primary instance in one region and read replicas in other regions.
- D
A zonal database deployment with periodic backups to Cloud Storage.
Show answer and explanation
Correct answer: C
Explanation
The correct answer is a multi-region deployment with a primary instance in one region and read replicas in other regions. This strategy ensures high availability and low latency for global users while optimizing costs. The primary instance handles write operations, and the read replicas provide fast read access in other regions, meeting the requirements without unnecessary overengineering.
- A. Incorrect.
This option provides high availability and low latency for global users but is significantly more expensive due to the maintenance of read-write instances in each region. It may be overkill for the given requirements.
- B. Incorrect.
While this option is cost-effective, it does not meet the requirement for low latency for users across multiple continents, as it is confined to a single region.
- C. Correct.
This option balances global availability, low latency, and disaster recovery with cost optimization. The primary instance handles writes, while read replicas in other regions ensure low-latency read access for global users.
- D. Incorrect.
A zonal deployment with backups provides the lowest cost but fails to meet the requirements for high availability and low latency for a global user base.