Microsoft Azure Data Fundamentals — Question 15

Your company has a reporting solution that has paginated reports. The reports query a dimensional model in a data warehouse.
Which type of processing does the reporting solution use?

Answer options

• A. stream processing
• B. batch processing
• C. Online Analytical Processing (OLAP)
• D. Online Transaction Processing (OLTP)

Correct answer: C

Explanation

The correct answer is C, Online Analytical Processing (OLAP), as it is designed for complex queries and analysis of data stored in a data warehouse. Stream processing is suited for real-time data, batch processing deals with large volumes of data processed at once, and OLTP is focused on transaction-oriented tasks, making them unsuitable for paginated report generation.