nerdexam
Microsoft

DP-900 · Question #274

You have a banking application that transfers money in to and out of accounts. Of which type of solution is this is an example?

The correct answer is A. online transaction processing (OLTP). Online Transaction Processing (OLTP) systems handle high volumes of short, real-time transactions such as deposits, withdrawals, and transfers. Banking applications are a canonical example of OLTP.

Submitted by kim_seoul· Mar 30, 2026Describe core data concepts

Question

You have a banking application that transfers money in to and out of accounts. Of which type of solution is this is an example?

Options

  • Aonline transaction processing (OLTP)
  • Bonline analytical processing (OLAP)
  • Cextract, transform and load (ETL)
  • Da data warehouse

How the community answered

(38 responses)
  • A
    95% (36)
  • B
    3% (1)
  • D
    3% (1)

Why each option

Online Transaction Processing (OLTP) systems handle high volumes of short, real-time transactions such as deposits, withdrawals, and transfers. Banking applications are a canonical example of OLTP.

Aonline transaction processing (OLTP)Correct

OLTP systems are designed for managing real-time transactional data with requirements for high concurrency, data integrity (ACID compliance), and fast insert/update/query operations on individual records. A banking application processing account transfers exemplifies OLTP because it performs frequent, small, discrete transactions that must be accurate and immediately consistent.

Bonline analytical processing (OLAP)

OLAP systems are designed for complex analytical queries over large historical datasets, such as trend analysis or financial reporting, not for managing individual real-time account transactions.

Cextract, transform and load (ETL)

ETL (Extract, Transform, Load) is a data pipeline process for moving and transforming data between systems, not a pattern for handling live banking transactions.

Da data warehouse

A data warehouse is an analytical store optimized for read-heavy reporting and historical analysis, not for processing real-time transactional operations like money transfers.

Concept tested: OLTP system identification and use cases

Source: https://learn.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-transaction-processing

Topics

#OLTP#transactional systems#banking applications

Community Discussion

No community discussion yet for this question.

Full DP-900 Practice