A digital streaming platform requires a database solution to ingest and query high-throughput user clickstream events in real time. The workload generates millions of event writes per second with sub-10 millisecond latency requirements, storing key-value pairs indexed by user ID and timestamp. The data does not require multi-table relational joins or ACID transactions across multiple keys. Which database service should you select to meet these technical requirements while minimizing operational complexity and cost?
- Provision Cloud Bigtable to handle high-throughput NoSQL key-value writes with consistent low latency.Answer
- BProvision Cloud Spanner to manage the clickstream data within a globally distributed relational database architecture.
- CExport real-time event logs to local disk and order GCP Transfer Appliance units to regularly transport physical media to Cloud Storage.
- DProvision a single Cloud SQL for PostgreSQL instance with public IP endpoints and rely exclusively on IAM roles to prevent data exfiltration.
Answer
Provision Cloud Bigtable to handle high-throughput NoSQL key-value writes with consistent low latency.
Cloud Bigtable is purpose-built for high-throughput, low-latency write workloads like real-time analytics, time-series data, and clickstream events indexed by row keys. It provides scalable NoSQL storage without the overhead of relational database management.
Step-by-Step Solution
Key Concept
Selecting GCP Storage Services Based on Access Patterns and Scalability Requirements