You need to run complex queries that aggregate sales data across the last five years to find yearly trends. This operation is highly resource-intensive and reads millions of rows. Which type of workload is this?

Direct Answer (Verified)Reviewed by Sunny (Senior Cloud Engineer)

Correct Answer: OLAP (Online Analytical Processing)

OLAP (Online Analytical Processing) systems are optimized for read-heavy, complex queries across large volumes of historical data, making them ideal for reporting, business intelli...

๐Ÿ“‹Part of Microsoft Certified: Azure Data Fundamentals (DP-900) ยท Azure Certification Practice
Real Exam ScenarioData Workloads

You need to run complex queries that aggregate sales data across the last five years to find yearly trends. This operation is highly resource-intensive and reads millions of rows. Which type of workload is this?

โœ“ Correct Answer & ExplanationData Workloads

Correct Answer

OLAP (Online Analytical Processing)

Why This Answer Is Correct

OLAP (Online Analytical Processing) systems are optimized for read-heavy, complex queries across large volumes of historical data, making them ideal for reporting, business intelligence, and finding long-term trends.

๐Ÿ“š What This Question Tests

This question evaluates your knowledge of Data Workloads โ€” a core concept tested in Microsoft Certified: Azure Data Fundamentals (DP-900). Understanding Data Workloads is essential for designing scalable, secure, and cost-effective cloud architectures. Mastery of this topic will help you answer scenario-based questions confidently on exam day.