Microsoft Azure Data FundamentalsDescribe core data conceptsEasy
A retail company wants to analyze customer purchasing behavior over the last five years to identify trends and make future business decisions. This analysis involves complex queries that aggregate data from multiple tables, perform calculations, and generate reports. The data is not frequently updated but is read heavily. Which common data workload type does this scenario represent?
- ABatch Processing
- BOnline Analytical Processing (OLAP)
- COnline Transaction Processing (OLTP)
- DStream Processing
Show answer & explanationAnswer & explanation
Correct answer: B. Online Analytical Processing (OLAP)
This scenario describes classic OLAP characteristics: analyzing historical data for trends, complex queries, aggregation, and heavy reads with infrequent updates, all aimed at business intelligence and decision-making.
Why the other options are wrong
- A. Batch processing is about processing data in large chunks, not necessarily the type of complex interactive querying described.
- C. OLTP is for day-to-day transactions with frequent, small updates and reads, not complex historical analysis.
- D. Stream processing is for real-time data analysis, not historical trend identification.
Online Analytical Processing (OLAP)
A computing method that enables users to easily and selectively extract and query data in order to analyze it from different points of view.
- Optimized for complex queries
- Analyzes historical data
- Supports business intelligence and reporting
Memory trick: OLAP is for 'analyzing' the past to predict the future.