Google Cloud Digital LeaderGeneral knowledge of Google CloudHard
A startup is deploying a new web application and expects rapid growth, requiring a highly available and scalable database that can handle both transactional and analytical workloads. They want a fully managed, serverless option that offers strong consistency and low latency for global users. Which Google Cloud database service should they choose?
- ASpanner
- BFirestore
- CBigtable
- DCloud SQL
Show answer & explanationAnswer & explanation
Correct answer: A. Spanner
Cloud Spanner is a globally distributed, strongly consistent, and highly available relational database service. It uniquely combines transactional consistency with horizontal scalability and supports both transactional and analytical workloads, making it ideal for the described requirements.
Why the other options are wrong
- B. Firestore is a NoSQL document database, offering global scalability but not the strong transactional consistency of a relational database at Spanner's scale.
- C. Bigtable is a wide-column NoSQL database, optimized for high-throughput, low-latency analytics, not strong transactional consistency across a global scale.
- D. Cloud SQL is a regional relational database, not globally distributed with strong consistency and horizontal scalability for global users.
Cloud Spanner
Cloud Spanner is a globally distributed, strongly consistent, and highly available relational database service built for mission-critical applications.
- Combines benefits of relational databases (transactions, SQL) with NoSQL scalability.
- Offers strong consistency globally.
- Suitable for both transactional and analytical workloads.
Memory trick: Spanner spans the globe with strong consistency.