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

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

Submitted by jian89· 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. NOTE: Each correct selection is worth one point.

Options

Adenormalized data
Bschema defined in a database
Cschema defined when reading unstructured data from a database
Dnormalized data
Elight writes and heavy reads
Fheavy writes and moderate reads

How the community answered

(20 responses)

B
90% (18)
C
5% (1)
E
5% (1)

Explanation

B: Typical traits of transactional data include: schema on write, strongly enforced. The schema is defined in a database. D: Transactional data tends to be highly normalized. F: Transactional data tends to be heavy writes, moderate reads. 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