Google Professional Cloud Database Engineer Question 29
Single answerGoogle Cloud PlatformYour company operates a globally distributed e-commerce platform with users across multiple continents. You need to choose a Google Cloud database deployment strategy that ensures high availability, low latency for users in different regions, and automatic failover in case of regional outages. However, your team also wants to minimize operational complexity and costs. Which deployment strategy should you choose?
- A
Deploy a multi-region database with automatic replication between regions.
- B
Deploy a regional database in a single region closest to the majority of your users.
- C
Deploy zonal databases in each zone and synchronize data manually between zones.
- D
Deploy regional databases in multiple regions and implement custom cross-region replication.
Show answer and explanation
Correct answer: A
Explanation
For a globally distributed platform, a multi-region database deployment best meets the requirements of high availability, low latency across regions, and automatic failover during regional outages, while keeping operational complexity manageable. Other options either fail to meet one or more of these requirements or introduce unnecessary complexity.
- A. Correct.
This is the correct answer as a multi-region database provides high availability, low latency for global users, and automatic failover with minimal operational complexity. Though it may have higher costs, it is the best fit for the use case described.
- B. Incorrect.
While this option minimizes costs, it does not account for users in other continents, and a single regional database does not provide failover in case of regional outages.
- C. Incorrect.
This option would be extremely complex to implement and manage, as manual synchronization between zonal databases is error-prone and not scalable.
- D. Incorrect.
While deploying regional databases in multiple regions addresses latency and availability, implementing custom cross-region replication adds significant operational complexity and is less efficient compared to a multi-region database.