CompTIA Data+ (DA0-002)Data Concepts and EnvironmentsMedium
A data engineer is designing a system to store sensor data from IoT devices. Each sensor periodically transmits readings that include a timestamp, device ID, and temperature. The engineer anticipates a very high volume of data, with frequent writes and less frequent reads, primarily for time-series analysis. Data consistency is important, but absolute ACID compliance for every single reading is not a strict requirement, prioritizing write availability and scalability. Which database type is most suitable?
- AKey-Value Store
- BDocument Database
- CTime-Series Database
- DRelational 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 with high write volumes and time-based analysis. They prioritize performance for this specific workload.
Why the other options are wrong
- A. Key-value stores offer high performance but lack the built-in time-series specific functions and optimizations needed for efficient analysis.
- B. Document databases could store the data but are not specifically optimized for the time-indexed nature and high write throughput of time-series data.
- D. Relational databases can struggle with the scale and write velocity of IoT data and are not optimized for time-series queries.
Time-Series Database
A database optimized for storing and retrieving data points that are indexed by time (e.g., sensor readings, stock prices).
- Designed for high write throughput and efficient time-based queries.
- Often includes features like data compression, retention policies, and specialized functions for time-series analysis.
- Commonly used in IoT, monitoring, and financial applications.
Memory trick: NoSQL databases are like specialized tools, each perfect for a particular job, not a one-size-fits-all wrench.