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

Practice question for this objective

Free sampleDescribe Core Data Conceptseasy

Analytical data processing typically uses read-only or read-mostly systems that store vast volumes of historical data or business metrics. Is this statement correct?

AYes Correct
BNo

Analytical processing is read-mostly over large volumes of historical data and snapshots. Analytical data processing relies on read-only or read-mostly systems that hold large volumes of historical data or business metrics, with analytics based on snapshots taken at a point in time.

Why A is correct: Correct. Analytical data processing relies on read-only or read-mostly systems that hold large volumes of historical data or business metrics, with analytics based on snapshots taken at a point in time.

Why B is wrong: Answering No would wrongly attribute high-volume read and write transactions to analytics; that pattern belongs to transactional OLTP systems, not analytical processing.

See more DP-900 practice questions, answers explained.

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.