A company needs to store petabytes of time-series IoT sensor data and query it with single-digit millisecond latency at millions of reads per second. The data has a simple key-value structure with timestamps. Which Google Cloud database is MOST appropriate?
Trap 1: Cloud Spanner
Spanner is a globally distributed relational database optimized for ACID transactions, not single-digit ms time-series reads at millions of QPS.
Trap 2: BigQuery
BigQuery is an analytics data warehouse with query latency measured in seconds. It is not designed for millisecond lookups at IoT scale.
Trap 3: Firestore
Firestore is a document database suited for mobile/web apps with hierarchical data. It does not scale to millions of QPS for time-series workloads.
- A
Cloud Spanner
Why wrong: Spanner is a globally distributed relational database optimized for ACID transactions, not single-digit ms time-series reads at millions of QPS.
- B
Cloud Bigtable
Bigtable is the correct choice: wide-column NoSQL, designed for time-series and IoT workloads, single-digit ms latency, and scales to millions of QPS with additional nodes.
- C
BigQuery
Why wrong: BigQuery is an analytics data warehouse with query latency measured in seconds. It is not designed for millisecond lookups at IoT scale.
- D
Firestore
Why wrong: Firestore is a document database suited for mobile/web apps with hierarchical data. It does not scale to millions of QPS for time-series workloads.