Microsoft Azure Data FundamentalsDescribe core data conceptsMedium
A retail company wants to analyze customer purchasing behavior over the last five years to identify trends, popular products, and effective marketing campaigns. The analysis involves complex queries, aggregations, and drilling down into various dimensions like product category, region, and time. Which common data workload BEST describes this scenario?
- AStream Processing
- BBatch Processing
- COnline Transaction Processing (OLTP)
- DOnline Analytical Processing (OLAP)
Show answer & explanationAnswer & explanation
Correct answer: D. Online Analytical Processing (OLAP)
Analyzing historical data for trends, aggregations, and multidimensional insights is the primary purpose of Online Analytical Processing (OLAP).
Why the other options are wrong
- A. Stream processing is for real-time data analysis, not historical trend analysis.
- B. Batch processing refers to how data is processed (in chunks), not the type of analytical workload.
- C. OLTP focuses on transactional efficiency, not complex historical analysis.
Online Analytical Processing (OLAP)
A computing method that enables users to easily and selectively extract and query data to analyze it from different points of view.
- Optimized for read-heavy analytical workloads.
- Often uses data cubes for fast, multidimensional analysis.
- Supports complex queries, aggregations, and drill-down/roll-up operations.
Memory trick: OLAP for Deep Dives, Not Daily Deeds