What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. (Choose three.) NOTE: Each correct selection is worth one point.

The correct answer is B. heavy writes and moderate reads D. schema on write F. normalized data. B: Transactional data tends to be heavy writes, moderate reads. D: Typical traits of transactional data include: schema on write, strongly enforced F: Transactional data tends to be highly normalized…

Submitted by daniela_cl· Mar 30, 2026Describe core data concepts

Question

What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. (Choose three.) NOTE: Each correct selection is worth one point.

Options

Adenormalized data
Bheavy writes and moderate reads
Clight writes and heavy reads
Dschema on write
Eschema on read
Fnormalized data

How the community answered

(34 responses)

B
91% (31)
C
3% (1)
E
6% (2)

Explanation

B: Transactional data tends to be heavy writes, moderate reads. D: Typical traits of transactional data include: schema on write, strongly enforced F: Transactional data tends to be highly normalized. https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-transaction-

Topics

#OLTP#normalized data#schema on write#transactional workload

Community Discussion

No community discussion yet for this question.

Full DP-900 Practice