Microsoft Azure Data Fundamentals DP-900 Practice Question

Transactional (OLTP) workloads typically handle a large number of short, interactive operations such as inserts, updates, and deletes, and they must preserve ACID (atomicity, consistency, isolation, durability) properties to ensure data integrity for each individual business transaction. Analytical (OLAP) workloads, in contrast, focus on reading large volumes of historical data, executing complex aggregations, and are often batch-oriented or read-only in nature. Therefore, the presence of many small, concurrent write operations that require strict consistency is a strong signal that the workload is transactional. The other options describe characteristics more typical of analytical workloads, such as large-scale aggregations, columnar storage optimized for scans, or infrequent, read-only dashboard refreshes.