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.
Question
Options
- Aonline transaction processing (OLTP)
- Bonline analytical processing (OLAP)
- Cextract, transform and load (ETL)
- Da data warehouse
How the community answered
(38 responses)- A95% (36)
- B3% (1)
- D3% (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.
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.
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.
ETL (Extract, Transform, Load) is a data pipeline process for moving and transforming data between systems, not a pattern for handling live banking transactions.
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
Community Discussion
No community discussion yet for this question.