CompTIA Data+ (DA0-002)Data Concepts and EnvironmentsMedium
A data engineer is building a data pipeline that processes real-time sensor readings from industrial machinery. Each reading includes a timestamp, a sensor ID, and a numerical value representing a specific metric (e.g., temperature, pressure). The primary use case is to monitor trends over time, detect anomalies, and perform aggregations on time intervals. Which database type is most appropriate for this scenario?
- ADocument Database
- BRelational Database
- CTime-Series Database
- DGraph Database
Show answer & explanationAnswer & explanation
Correct answer: C. Time-Series Database
Time-series databases are specifically optimized for storing and querying data points that are heavily indexed by time, making them ideal for sensor data, monitoring trends, and performing time-based aggregations efficiently.
Why the other options are wrong
- A. Document databases are flexible for semi-structured data but lack the time-specific indexing and query optimizations of a time-series database.
- B. Relational databases can store time-series data but are not optimized for its unique access patterns (e.g., range queries, aggregations over time).
- D. Graph databases are designed for highly interconnected data, not for sequential, time-stamped sensor readings.
Time-Series Database (TSDB)
A database optimized for storing and retrieving time-stamped data, or time series. It is designed to handle high write and query loads for data that changes over time.
- Data points are indexed by time.
- Optimized for high ingest rates.
- Efficient for time-based queries and aggregations.
- Common for IoT, monitoring, financial data.
- Examples: InfluxDB, Prometheus, TimescaleDB.
Memory trick: TSDB: Time Stamped Data for Trends.