Microsoft Azure Data FundamentalsDescribe an analytics workload on AzureEasy
A logistics company wants to track the location of its delivery trucks in real time and analyze historical route efficiency. They need a database solution that can efficiently store and query data points with associated timestamps. Which type of database is best suited for this requirement?
- 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 that are indexed by time, making them ideal for scenarios involving real-time tracking and historical analysis of events over time.
Why the other options are wrong
- A. Relational databases can store time-series data but are not as performant or scalable for high-volume time-indexed queries.
- B. Graph databases are used for highly interconnected data, not for time-stamped event data.
- D. Document databases are designed for semi-structured data, not optimized for time-indexed data.
Time-Series Database
A database optimized for storing and analyzing data points that are indexed by time, commonly used for monitoring, sensor data, and IoT applications.
- Designed for data with a timestamp component.
- Efficient for high-volume inserts and time-based queries.
- Supports aggregation and analysis over time windows.
Memory trick: Time-travelers always check the clock.