Skip to main content
CloudCertPrep
DP-900Domain 1: Describe Core Data ConceptsCore Data ConceptseasySingle choice

An order-entry system processes thousands of small insert/update transactions per second with millisecond response requirements. Which workload type?

A.OLAP — analytical processing

OLAP runs analytical queries over large historical datasets.

B.OLTP — transactional processing

High-volume small transactions = OLTP. Correct.

C.Batch processing

Batch describes scheduling, not the transaction pattern.

D.Data warehousing

Warehousing is analytical storage — not transaction processing.

Why this answer

OLTP = many small read/write transactions, low latency, current data — the classic order-entry/banking workload. OLAP/warehousing = large scans and aggregations over historical data for analysis.

Correct answer: B · Last reviewed 2026-11-05

Practice this interactively

Answer without seeing the solution first in the Core Data Concepts practice session.

Practice Core Data Concepts