Microsoft Azure Data Fundamentals — Question 103

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.

Answer options

• A. denormalized data
• B. heavy writes and moderate reads
• C. light writes and heavy reads
• D. schema on write
• E. schema on read
• F. normalized data

Correct answer: B, D, F

Explanation

The correct answers are B, D, and F because OLTP systems typically involve a high number of write operations (B), utilize a schema on write to structure the data at the time of writing (D), and often store data in a normalized format to reduce redundancy (F). Options A (denormalized data) and C (light writes and heavy reads) do not accurately describe OLTP workloads, while E (schema on read) is more characteristic of data warehousing systems.