Google Professional Cloud Database Engineer Question 27
Single answerGoogle Cloud PlatformYour company runs a global e-commerce platform that requires high availability, low latency for users across multiple continents, and disaster recovery capabilities. You are tasked with selecting a database deployment strategy on Google Cloud. Which of the following deployment strategies would best meet these requirements?
- A
Zonal deployment using Cloud SQL with a single zone instance
- B
Regional deployment using Cloud Spanner in a single region
- C
Multi-region deployment using Cloud Spanner with strong consistency
- D
Regional deployment using Firestore in Datastore mode
Show answer and explanation
Correct answer: C
Explanation
Multi-region deployment using Cloud Spanner is the best choice for a global e-commerce platform requiring high availability, low latency for users across multiple continents, and disaster recovery. Spanner's multi-region configuration ensures data is replicated across multiple regions, providing resilience to regional failures, while its strong consistency guarantees accurate data across all regions. Other options lack the necessary features to fully meet the requirements of the scenario.
- A. Incorrect.
Zonal deployment using Cloud SQL provides low cost and simplicity but does not meet high availability or disaster recovery requirements since it is limited to a single zone. A zonal failure could lead to service downtime.
- B. Incorrect.
Regional deployment using Cloud Spanner ensures availability within a single region but does not adequately address the needs of global low latency or disaster recovery for users across multiple continents.
- C. Correct.
Multi-region deployment using Cloud Spanner provides high availability, global low latency, and disaster recovery capabilities. It is designed for applications with global user bases and supports strong consistency, making it ideal for the stated requirements.
- D. Incorrect.
Regional deployment using Firestore in Datastore mode ensures availability within a single region but does not offer the multi-region redundancy or global low latency required for this scenario.