nerdexam
Microsoft

DP-900 · Question #29

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.

Sign in or unlock DP-900 to reveal the answer and full explanation for question #29. The question stem and answer options stay visible for context.

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

Unlock DP-900 to see the answer

You've previewed enough free DP-900 questions. Unlock DP-900 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#OLTP#normalized data#schema on write#transactional workload
Full DP-900 Practice