GSLC · Question #188
Which of the following applications would NOT be considered an OLTP application?
The correct answer is A. Fraud detection. Fraud detection relies on complex analytical queries across historical data, classifying it as an OLAP workload rather than an OLTP application.
Question
Which of the following applications would NOT be considered an OLTP application?
Options
- AFraud detection
- BBadge reader
- CeCommerce site
- DStock-trading site
How the community answered
(38 responses)- A79% (30)
- B5% (2)
- C3% (1)
- D13% (5)
Why each option
Fraud detection relies on complex analytical queries across historical data, classifying it as an OLAP workload rather than an OLTP application.
Fraud detection systems analyze large volumes of past transactions using complex pattern-matching, statistical models, and multi-dimensional queries to identify anomalies - characteristics of OLAP, not OLTP. OLTP applications are defined by high-volume, short-duration, atomic transactions such as inserts and updates, whereas fraud detection requires heavy read-intensive analytical processing that is incompatible with the OLTP model.
A badge reader records individual access events as simple, discrete insert transactions with minimal processing, fitting the high-volume, low-complexity definition of OLTP.
An eCommerce site continuously processes orders, payments, and inventory updates as atomic transactions requiring high concurrency and data integrity, which are the defining traits of OLTP.
A stock-trading site executes buy and sell orders as real-time atomic transactions requiring high throughput and strict consistency guarantees, making it a classic OLTP application.
Concept tested: OLTP vs OLAP application classification
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.