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.Cevap
- 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.
Cevap
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.
Adım Adım Çözüm
Anahtar Kavram
Selecting GCP Storage Services Based on Access Patterns and Scalability Requirements