nerdexam
GIAC

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.

Security Architecture & Engineering

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)
  • A
    79% (30)
  • B
    5% (2)
  • C
    3% (1)
  • D
    13% (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.

AFraud detectionCorrect

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.

BBadge reader

A badge reader records individual access events as simple, discrete insert transactions with minimal processing, fitting the high-volume, low-complexity definition of OLTP.

CeCommerce site

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.

DStock-trading site

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

#OLTP#OLAP#fraud detection#application classification

Community Discussion

No community discussion yet for this question.

Full GSLC Practice