nerdexam
Microsoft

DP-900 · Question #28

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?

The correct answer is C. Online Analytical Processing (OLAP). https://datawarehouseinfo.com/how-does-oltp-differ-from-olap-database/

Submitted by akirajp· Mar 30, 2026Describe an analytics workload on Azure

Question

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?

Options

  • Astream processing
  • Bbatch processing
  • COnline Analytical Processing (OLAP)
  • DOnline Transaction Processing (OLTP)

How the community answered

(36 responses)
  • A
    3% (1)
  • B
    6% (2)
  • C
    89% (32)
  • D
    3% (1)

Explanation

https://datawarehouseinfo.com/how-does-oltp-differ-from-olap-database/

Topics

#OLAP#dimensional model#data warehouse#paginated reports

Community Discussion

No community discussion yet for this question.

Full DP-900 Practice