Google Cloud Digital LeaderInfrastructure modernization with Google CloudMedium
A global e-commerce company is experiencing rapid growth and needs to ensure its transactional database can scale horizontally across multiple regions while maintaining strong consistency and high availability. They also require SQL query capabilities. Which Google Cloud database service is the most appropriate solution?
- ACloud SQL
- BFirestore
- CCloud Bigtable
- DCloud Spanner
Show answer & explanationAnswer & explanation
Correct answer: D. Cloud Spanner
Cloud Spanner is a globally distributed, strongly consistent, and horizontally scalable relational database service that supports standard SQL. It is designed for applications requiring high availability and transactional consistency across regions, making it ideal for the e-commerce company's needs.
Why the other options are wrong
- A. Cloud SQL is a regional relational database, not designed for global horizontal scaling with strong consistency across multiple regions.
- B. Firestore is a NoSQL document database, lacking SQL capabilities and strong transactional consistency across global regions in the same way Spanner does.
- C. Cloud Bigtable is a NoSQL wide-column database, designed for analytical workloads and high throughput, not transactional consistency with SQL across global regions.
Cloud Spanner
A globally distributed, strongly consistent, and horizontally scalable relational database service offered by Google Cloud.
- Offers strong transactional consistency.
- Scales horizontally across regions and continents.
- Supports standard SQL queries.
Memory trick: Spanner stretches globally, strong and speedy.