CompTIA Data+ (DA0-002)Data Concepts and EnvironmentsMedium
A data architect is designing a system to store streaming sensor data from thousands of IoT devices. Each data point consists of a timestamp, device ID, sensor type, and a numerical value. The primary access pattern for this data will involve querying by time range and device ID to retrieve sequences of sensor readings. Which database type is best suited for this use case?
- ARelational Database
- BGraph Database
- CTime-Series Database
- DDocument Database
Show answer & explanationAnswer & explanation
Correct answer: C. Time-Series Database
Time-series databases are specifically optimized for storing and querying data points indexed by time, making them ideal for IoT sensor data where timestamps are a critical component and queries often involve time ranges or aggregations over time.
Why the other options are wrong
- A. While a relational database could store this data, it would not be as performant or efficient for time-based queries at scale compared to a specialized time-series database.
- B. Graph databases are used for highly interconnected data, which is not the primary characteristic of independent sensor readings.
- D. Document databases are for flexible, semi-structured data, but the core requirement here is time-indexed data for efficient range queries, which a time-series database handles better.
Time-Series Database
A database optimized for storing and retrieving data points that are indexed by time, making them ideal for handling metrics, events, and sensor data over periods.
- Optimized for time-stamped data.
- Efficient for time-range queries and aggregations.
- High write and read throughput for sequential data.
- Commonly used for IoT, monitoring, and financial data.
Memory trick: Remember 'Time-Series' for 'Tick-Tock' data that changes over time.