Microsoft Azure Data Fundamentals — Question 108

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 defined in a database
• E. schema defined when reading unstructured data from a database
• F. normalized data

Correct answer: B, D, F

Explanation

The correct answers B, D, and F highlight the essential traits of OLTP systems, which emphasize heavy write operations and structured schemas. Option A is incorrect because OLTP typically utilizes normalized data to reduce redundancy. Option C is not suitable as OLTP relies on heavier write activity than read activity, while option E is irrelevant to OLTP as it pertains to unstructured data.