DP-900 · Question #273
Which activity is most common for transactional workloads?
The correct answer is A. recording small units of work events in real time. Online Transaction Processing (OLTP) systems are characterized by recording small, discrete units of work in real time, such as individual sales, bookings, or account updates. Analytical and reporting workloads have different characteristics.
Question
Options
- Arecording small units of work events in real time
- Baggregating massive amounts of data
- Cproducing complex reports
- Dperforming self-service data exploration
How the community answered
(19 responses)- A95% (18)
- C5% (1)
Why each option
Online Transaction Processing (OLTP) systems are characterized by recording small, discrete units of work in real time, such as individual sales, bookings, or account updates. Analytical and reporting workloads have different characteristics.
Transactional workloads in OLTP systems are designed to capture and record individual business events - such as a purchase, a login, or an account transfer - as they happen in real time. These are small, frequent, and highly normalized operations optimized for fast inserts, updates, and point lookups rather than complex aggregations.
Aggregating massive amounts of data is characteristic of analytical workloads such as OLAP or data warehouse queries, not transactional OLTP systems.
Producing complex reports is an analytical activity typically performed by OLAP systems, data warehouses, or reporting tools, not OLTP systems.
Self-service data exploration is associated with business intelligence tools and analytical platforms, not transactional processing systems.
Concept tested: Characteristics of transactional (OLTP) workloads
Source: https://learn.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-transaction-processing
Topics
Community Discussion
No community discussion yet for this question.