Microsoft Azure Data FundamentalsDescribe core data conceptsEasy
A financial institution needs to analyze historical stock market data to identify trends and make predictions. This data is collected daily, is highly structured, and needs to be optimized for complex analytical queries that aggregate information over long periods. Which type of data workload does this scenario BEST represent?
- ABatch Processing
- BOnline Analytical Processing (OLAP)
- CStream Processing
- DOnline Transaction Processing (OLTP)
Show answer & explanationAnswer & explanation
Correct answer: B. Online Analytical Processing (OLAP)
Online Analytical Processing (OLAP) workloads are characterized by complex queries on large volumes of historical data, typically used for business intelligence, reporting, and analytical purposes, which aligns perfectly with analyzing historical stock market data for trends.
Why the other options are wrong
- A. Batch processing involves processing large volumes of data periodically, but OLAP specifically refers to the analytical querying nature.
- C. Stream processing handles data in real-time as it arrives, not primarily historical analysis.
- D. OLTP is for high-volume, short transactions, like order entry, not complex historical analysis.
Online Analytical Processing (OLAP)
OLAP is a category of software tools that provide analysis of data for business intelligence. OLAP systems are optimized for complex data analysis rather than transaction processing.
- Focuses on historical data and trend analysis.
- Optimized for complex queries and aggregations.
- Used for business intelligence, reporting, and forecasting.
Memory trick: OLAP helps you 'look' at the 'past'.