Amazon Timestream for IoT
A company is building a real-time analytics dashboard from IoT sensor data. Data arrives as time-series with millions of writes per second. The dashboard queries the last hour of data with aggregations. Which database design is most cost-effective?
Quick Answer
Amazon Timestream is the correct choice because it is purpose-built for IoT time-series data, offering automatic tiered storage that keeps recent data in memory for fast queries and moves historical data to magnetic storage at lower cost, while its built-in aggregation functions handle millions of writes per second without manual sharding or TTL management. On the AWS Certified Database Specialty DBS-C01 exam, this scenario tests your understanding of purpose-built databases versus general-purpose options like DynamoDB or RDS, which would require complex partitioning and retention policies for time-series workloads. A common trap is choosing DynamoDB with TTL, but Timestream’s serverless model and optimized time-based aggregations make it far more cost-effective for real-time dashboards querying the last hour of data. Memory tip: think “TimeStream = Time + Stream” — it streams recent data in memory and streams old data to magnetic, saving you from manual stream management.
⚠ Common exam trap
Candidates often choose DynamoDB with TTL and DAX because they associate it with high write throughput and caching, but they overlook that time-series aggregation queries require native time-based functions and cost-efficient storage tiering, which Timestream uniquely provides.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Amazon Timestream
Amazon Timestream is purpose-built for time-series data, offering automatic tiered storage (in-memory for recent data and magnetic for historical) and built-in aggregation functions optimized for time-based queries. This design handles millions of writes per second cost-effectively, as it eliminates the need for manual sharding or TTL management, and its serverless model charges only for data written and queried, making it ideal for real-time analytics on the last hour of IoT sensor data.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Amazon DynamoDB with TTL and DAX
Why it's wrong here
DynamoDB write costs are high for millions writes/sec, and DAX helps reads only.
- ✗
Amazon Redshift with streaming ingestion
Why it's wrong here
Redshift is for batch analytics, higher latency and cost.
- ✓
Amazon Timestream
Why this is correct
Optimized for time-series with low cost for high write throughput and efficient recent data queries.
- ✗
Amazon RDS for PostgreSQL with TimescaleDB extension
Why it's wrong here
RDS has write throughput limits and scaling challenges at millions writes/sec.
Quick reference
Cloud Service Model Comparison
| Model | You Manage | Provider Manages | Examples |
|---|---|---|---|
| IaaS | OS, runtime, apps, data | Hardware, hypervisor, networking | EC2, Azure VMs, GCP Compute Engine |
| PaaS | Apps and data | OS, runtime, middleware, hardware | Elastic Beanstalk, Azure App Service |
| SaaS | Data and settings only | Everything else | Microsoft 365, Salesforce, Workday |
| FaaS / Serverless | Function code only | Infra, scaling, runtime | Lambda, Azure Functions, Cloud Run |
| CaaS | Containers and apps | Kubernetes, OS, hardware | EKS, AKS, GKE |
Go deeper
Related to this question
About these practice questions
One of 1,663 original DBS-C01 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
Same concept, more angles
1 more way this is tested on DBS-C01
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. A company is building a real-time analytics dashboard for IoT sensor data. The data arrives as JSON and needs to be stored in a way that supports fast ingestion and complex queries. Which database service is best suited?
easy- A.Amazon RDS for PostgreSQL
- B.Amazon DynamoDB with TTL
- ✓ C.Amazon Timestream
- D.Amazon Redshift
Why C: Amazon Timestream is purpose-built for time-series data, offering fast ingestion of JSON sensor data and optimized storage for time-based queries. It automatically manages retention, compression, and tiering (memory and magnetic store), enabling complex analytical queries (e.g., window functions, interpolation) without manual tuning. This makes it ideal for real-time IoT analytics dashboards.
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DBS-C01 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DBS-C01 exam.