DP-900 - Describe Core Data Concepts - Section 1.3

Describe common data workloads including transactional and analytical processing.

Compare OLTP workloads (high-frequency, short transactions) with OLAP workloads (complex aggregations over large datasets), and distinguish batch processing from stream processing. Recognise where ETL and ELT pipelines fit and when each pattern applies.

OLTPOLAPbatch processingstream processingETL and ELT

More in this domain

Back to all Describe Core Data Concepts objectives, or the DP-900 cert hub.

Examworthy is not affiliated with or endorsed by Microsoft. Original, blueprint-aligned practice material only.