CAF-3 · Chapter 6 · Question 6 of 15
A nationwide supermarket chain processes tens of thousands of customer checkout transactions every hour. The system must quickly insert, update, and delete these short, atomic records in real-time. Which type of system is the supermarket using?
Test yourself: pick an answer
Reveal answer & explanation
Correct answer: B) Online Transaction Processing (OLTP)
Explanation
Online Transaction Processing (OLTP) systems are optimized for handling a large volume of short, fast, and atomic real-time transactions, such as processing daily sales
More Data Warehouse Schemas & Data Marts MCQs
- Q8During the creation of a data warehouse, raw data is pulled from a CRM system, an ERP system, and several flat files. Before this data is…
- Q9In the ETL process, standardizing date formats across different systems (e.g., converting DD/MM/YYYY to MM/DD/YYYY) and calculating new…
- Q10To save processing time and bandwidth, a company updates its data warehouse every midnight by only bringing in the new transactions that…
- Q11A data architect designs a schema for a new data warehouse. The design features a single central 'Fact Table' containing total sales…
- Q12To save storage space and ensure stricter data integrity, a database engineer modifies a Star Schema by breaking down the 'Product'…