Google Cloud Digital LeaderDigital transformation with Google CloudMedium
A media company is experiencing rapid growth in its user base and needs a highly available, globally distributed database solution to store user profiles and content metadata. The database must handle massive read and write operations with consistent low latency, even during peak traffic. Which Google Cloud database service is most suitable for this requirement?
- ACloud SQL for relational database management.
- BBigQuery for data warehousing and analytics.
- CFirestore for NoSQL document database.
- DCloud Spanner for globally distributed relational database.
Show answer & explanationAnswer & explanation
Correct answer: D. Cloud Spanner for globally distributed relational database.
Cloud Spanner is designed for global scale, high availability, strong consistency, and transactional integrity, making it ideal for the described scenario of massive, globally distributed read/write operations with low latency.
Why the other options are wrong
- A. Cloud SQL is a regional relational database and might struggle with global distribution and massive, consistent low-latency writes at scale.
- B. BigQuery is a data warehouse for analytics, not an operational database for real-time transactional user data.
- C. Firestore is a NoSQL document database, good for mobile/web apps, but for 'globally distributed' and 'consistent low latency' with transactional integrity at massive scale, Spanner is often preferred.
Cloud Spanner
A globally distributed, strongly consistent, and horizontally scalable relational database service offered by Google Cloud.
- Combines the benefits of relational databases (SQL, strong consistency) with NoSQL scalability.
- Designed for mission-critical applications requiring high availability and low latency at global scale.
- Supports ACID transactions across continents.
Memory trick: SQL for local, Spanner for Global, BigQuery for warehouse, Firestore for NoSQL.