AWS Certified Data Engineer – AssociateData Storage and ManagementEasy

A data analytics team requires a highly performant, fully managed, and scalable time-series database for ingesting and querying billions of sensor data points per day from IoT devices. They need to analyze trends and anomalies in near real-time. Which AWS service is best suited for this requirement?

  1. AAmazon RDS for PostgreSQL
  2. BAmazon Redshift
  3. CAmazon DynamoDB
  4. DAmazon Timestream
Show answer & explanation

Correct answer: D. Amazon Timestream

Amazon Timestream is specifically designed for time-series data, offering high-performance ingestion and querying, automatic scaling, and cost-effective storage for billions of events per day. Its architecture is optimized for the unique characteristics of time-series workloads.

Why the other options are wrong

  • A. RDS for PostgreSQL is a relational database, not optimized for the scale and specific query patterns of time-series data.
  • B. Redshift is a data warehouse optimized for analytical queries over large datasets, but not for real-time ingestion and time-series specific functions.
  • C. DynamoDB is a NoSQL database but not optimized for time-series data's append-only, high-volume nature and specialized queries.

Amazon Timestream

A fast, scalable, and serverless time-series database service for IoT and operational applications.

  • Optimized for time-series data (e.g., sensor data, application logs).
  • High-performance ingestion and querying.
  • Serverless and scales automatically.
  • Cost-effective storage with tiered storage.

Memory trick: Time's a stream, for sensors keen.

More Data Storage and Management questions