Microsoft Azure Data FundamentalsDescribe an analytics workload on AzureHard
A logistics company wants to track the real-time location of its delivery vehicles and optimize routes. They are collecting GPS coordinates every few seconds from thousands of vehicles. This high-volume, continuous data needs to be stored efficiently for immediate analysis and historical playback. Which type of data storage is best suited for this continuously arriving, time-series data?
- AGraph Database
- BRelational Database
- CDocument Database
- DTime-Series Database
Show answer & explanationAnswer & explanation
Correct answer: D. Time-Series Database
Time-series databases are specifically optimized for storing, querying, and analyzing data points that are indexed by time, making them ideal for high-volume, continuously arriving sensor data like GPS coordinates.
Why the other options are wrong
- A. Graph databases are designed for data with complex relationships (e.g., social networks), not for high-volume, sequential time-stamped events.
- B. Relational databases can store time-series data but are not optimized for the high ingest rates, storage efficiency, and specific query patterns common in time-series workloads, leading to performance and cost issues at scale.
- C. Document databases are good for flexible schemas but not inherently optimized for the unique characteristics of time-series data (e.g., sequential writes, timestamp-based queries, aggregations over time windows).
Time-Series Database
A database optimized for storing, retrieving, and analyzing data points that are time-stamped and arrive in a continuous stream, often from sensors or monitoring systems.
- Optimized for high-volume writes and reads over time ranges.
- Efficiently stores sequential data points (e.g., sensor readings, metrics).
- Supports specialized functions for time-based aggregations and interpolation.
Memory trick: Time-series databases are perfect for data that 'ticks' and 'tracks'.