AI0-001 AI Models and Data Engineering Practice Question
A data engineer is building a pipeline to ingest streaming data from IoT sensors. Which data storage solution is best suited for real-time analytics on timestamped sensor readings?
⚠ Common exam trap
CompTIA often tests the misconception that 'any database can handle time-series data if you add a timestamp column,' ignoring the fundamental architectural differences in storage engines, indexing, and write optimization that make TSDBs the only viable choice for real-time streaming analytics.
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
✓
Time-series database
Time-series databases (TSDBs) are optimized for high-ingest rates of timestamped data and provide efficient downsampling, retention policies, and time-based aggregation functions. For IoT sensor streaming, a TSDB like InfluxDB or TimescaleDB delivers sub-second query performance on time-range scans, which is essential for real-time analytics.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Data warehouse
Why it's wrong here
A data warehouse stores structured, schema-on-write data loaded in batches, so it cannot ingest continuous high-velocity sensor streams for immediate querying. It is the right choice for consolidated historical reporting and BI over cleansed, modelled datasets.
- ✗
Relational database
Why it's wrong here
A relational database enforces fixed schemas and row-based storage, so ingesting high-velocity timestamped sensor streams incurs write contention and cannot serve real-time aggregations efficiently. It is tempting because relational databases excel at transactional integrity and complex joins across structured business records — the right choice for order processing or inventory systems, not continuous IoT telemetry.
- ✗
Data lake
Why it's wrong here
A data lake stores raw files without indexing or time-partitioned query engines, so timestamped sensor readings cannot be queried at low latency. It is the right choice for cheap long-term retention of varied raw data for later batch processing.
- ✓
Time-series database
Why this is correct
Time-series databases index on timestamp and exploit temporal locality, giving fast range scans and downsampling across sensor readings. This directly satisfies the real-time analytics constraint on timestamped IoT data, where relational stores would bottleneck on high-velocity writes and time-window aggregations.
About these practice questions
Courseiva writes every AI0-001 question from scratch — 962 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This AI0-001 practice question is part of Courseiva's free CompTIA 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 AI0-001 exam.