Skip to content
PCA Practice
SQ40

A company needs to store 500 TB of time-series IoT data with single-millisecond read latency for key lookups but does NOT need SQL joins or complex transactions. Which database is best?

  1. ABigtable
  2. BBigQuery
  3. CCloud SQL for PostgreSQL
  4. DCloud Spanner
Show answer

Answer: A

Bigtable excels at massive-scale time-series data with single-digit millisecond latency for key-based lookups. It doesn't support SQL joins or ACID transactions, which aren't needed here. BigQuery is for analytics, not low-latency lookups.

← SQ39Practice this topicSQ41 →