DP-900 Question #274: Real Exam Question with Answer & Explanation

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

Explanation

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.

Common mistakes.

• B. 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.
• C. ETL (Extract, Transform, Load) is a data pipeline process for moving and transforming data between systems, not a pattern for handling live banking transactions.
• D. 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

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

No community discussion yet for this question.