Google Associate Cloud EngineerDeploying and implementing a cloud solutionHard
A company is building a new application that requires a highly available, globally consistent, and strongly transactional database for critical business operations. The database needs to scale horizontally to handle millions of transactions per second and petabytes of data without sacrificing consistency. Which Google Cloud database service should they choose?
- ACloud SQL
- BCloud Firestore in Native mode
- CCloud Spanner
- DMemorystore for Redis
Show answer & explanationAnswer & explanation
Correct answer: C. Cloud Spanner
Cloud Spanner is a globally distributed, strongly consistent, relational database service that combines the benefits of relational databases with the horizontal scalability of NoSQL databases, making it ideal for mission-critical applications requiring high availability and strong transactional consistency at global scale.
Why the other options are wrong
- A. Cloud SQL is a regional relational database and does not offer global consistency or horizontal scalability to 'millions of transactions per second' at petabyte scale.
- B. Cloud Firestore is a NoSQL document database, offering eventual consistency by default and not strong transactional consistency across a globally distributed system at the same level as Spanner.
- D. Memorystore for Redis is an in-memory data store for caching, not a primary transactional database for critical business operations.
Google Cloud Spanner
A globally distributed, strongly consistent, and horizontally scalable relational database service designed for mission-critical applications.
- Combines relational database features with NoSQL scalability.
- Offers global transactional consistency.
- Provides 99.999% availability for multi-region instances.
Memory trick: Spanner 'spans' the 'globe' with 'strong' consistency.