Google Cloud Digital LeaderInfrastructure modernization with Google CloudHard
An online retail giant needs to process massive amounts of clickstream data (hundreds of terabytes daily) from its website and mobile apps to personalize user experiences and optimize product recommendations in near real-time. This data is semi-structured and needs to be analyzed with high throughput and low latency. The solution must be highly scalable and cost-effective. Which Google Cloud database product is best suited for this use case?
- AFirestore
- BCloud Spanner
- CCloud SQL
- DCloud Bigtable
Show answer & explanationAnswer & explanation
Correct answer: D. Cloud Bigtable
Cloud Bigtable is a fully managed, NoSQL wide-column database specifically designed for large analytical and operational workloads that require high throughput and low latency for massive datasets, making it ideal for clickstream analysis and real-time personalization.
Why the other options are wrong
- A. Firestore is a document database suitable for mobile/web apps, but typically not for the extreme scale (hundreds of TB daily) and high throughput/low latency analytical needs of clickstream data.
- B. Cloud Spanner is a globally distributed relational database, overkill and not optimized for semi-structured, high-throughput, low-latency analytics.
- C. Cloud SQL is a relational database, not designed for semi-structured data at hundreds of terabytes daily with high throughput/low latency requirements.
Cloud Bigtable
A fully managed, scalable NoSQL wide-column database service for large analytical and operational workloads, handling petabytes of data with high throughput and low latency.
- Optimized for high-throughput, low-latency workloads
- Ideal for time-series, IoT, and operational analytics (e.g., clickstream)
- NoSQL wide-column store, compatible with HBase API
Memory trick: Bigtable: Big data, big speed, for your big analytical needs.