Microsoft Azure Data Fundamentals DP-900 Practice Question

Transactional (OLTP) workloads focus on processing large numbers of short, atomic operations that modify current operational data. They therefore require fast inserts, updates, and deletes, and must guarantee ACID properties so that each business transaction is completed reliably even when many users work concurrently. Analytical (OLAP) workloads, in contrast, typically store historical data, are optimized for read-only aggregations, rely on denormalized schemas such as star or snowflake, and often load data in periodic batches. Because of these differences, a system whose primary trait is frequent, small read/write transactions with ACID guarantees is unmistakably transactional, whereas the other options describe analytical characteristics.