Microsoft Azure Data FundamentalsDescribe core data conceptsHard
A weather station continuously collects temperature, humidity, and pressure readings every minute. This data needs to be stored and made available for near real-time dashboards and historical trend analysis. The volume of data is high, and the primary access pattern involves querying data points over specific time intervals. Which type of data workload and corresponding storage combination is MOST appropriate?
- AOLTP workload with Azure SQL Database
- BOLAP workload with Azure Synapse Analytics
- CBatch Processing workload with Azure Data Lake Storage Gen2
- DStream Processing workload with Azure Time Series Insights
Show answer & explanationAnswer & explanation
Correct answer: D. Stream Processing workload with Azure Time Series Insights
The continuous collection of readings every minute indicates a stream processing workload. Storing and querying this time-stamped data for near real-time dashboards and historical trend analysis is best handled by a service like Azure Time Series Insights, which is specifically optimized for IoT and time series data, combining stream processing with specialized storage.
Why the other options are wrong
- A. OLTP is for transactional data, not continuous time-series sensor data.
- B. OLAP and Synapse Analytics are for general analytical workloads, but Time Series Insights is more specialized and efficient for this specific type of data and access pattern.
- C. Batch processing is not suitable for near real-time requirements, and Data Lake Storage is general-purpose, not optimized for time-series queries.
Azure Time Series Insights
Azure Time Series Insights is an end-to-end platform-as-a-service (PaaS) for collecting, processing, storing, querying, and visualizing time series data at IoT scale.
- Optimized for IoT and time-series data.
- Enables near real-time and historical analysis.
- Provides rich visualization and query capabilities over time-stamped data.
Memory trick: Time Series Insights helps you 'see' the 'time' and 'stream' it.