A platform must ingest millions of IoT sensor readings per hour and query them with time-range scans. Which AWS database is purpose-built for this workload?
Show answer and explanation
Answer: B
Timestream is a serverless time-series database. Its engine treats time as a first-class dimension with purpose-built functions for windows, interpolation, and smoothing, and it automatically keeps recent data in a fast in-memory store while aging older data into a cost-optimized magnetic store — with no lifecycle jobs to build or manage.
Why the other options are wrong
- A. PostgreSQL can hold the data, but ingesting millions of points per hour means managing provisioned instances, retention jobs, and table maintenance by hand; the extension doesn't make it serverless or lifecycle-managed.
- C. DynamoDB can model a timestamp sort key well, but time-series functions, data lifecycle tiering, and aggregation affordances all have to be built in application code.
- D. Redshift is warehouse-grade analytics over historical snapshots; continuous per-second ingestion of sensor streams is neither cheap nor its design center.