Google Professional Cloud Database Engineer Question 231
Select 3Google Cloud PlatformYou are designing a database architecture for a global e-commerce platform that requires high availability and scalability to handle millions of concurrent users. The platform must ensure low latency for users across multiple regions and automatic failover in case of regional outages. Which combination of Google Cloud services and configurations should you choose?
- A
Use Cloud Spanner with multi-region configuration and strong consistency.
- B
Use Cloud SQL with a single-zone instance to minimize cost.
- C
Use Memorystore for caching frequently accessed data to reduce latency.
- D
Use Firestore in Native mode with multi-region locations for global scalability.
- E
Use Bigtable with replication configured across multiple regions for low-latency reads.
Show answer and explanation
Correct answers: A, C, D
Explanation
For a global e-commerce platform with high availability and scalability requirements, Cloud Spanner with a multi-region configuration ensures strong consistency and automatic failover, while Firestore in Native mode provides a scalable and globally distributed NoSQL database. Memorystore complements these solutions by providing caching to reduce latency for frequently accessed data. Cloud SQL and Bigtable, while valuable for certain use cases, do not meet the requirements for this specific scenario.
- A. Correct.
Cloud Spanner with multi-region configuration provides strong consistency, high availability, and scalability, making it an ideal choice for a global application with high availability requirements.
- B. Incorrect.
Cloud SQL with a single-zone instance does not meet the high availability requirement, as it lacks multi-region failover support and could lead to downtime during a regional outage.
- C. Correct.
Memorystore can significantly reduce latency by caching frequently accessed data, which enhances the overall user experience during high traffic.
- D. Correct.
Firestore in Native mode with multi-region locations is optimized for global scalability and low-latency data access, making it a suitable option for applications with global user bases.
- E. Incorrect.
Bigtable with replication across multiple regions is ideal for analytical workloads and low-latency reads, but it does not inherently provide the strong consistency and relational features required for a transactional e-commerce platform.