Microsoft Azure Data FundamentalsDescribe core data conceptsHard
A global e-commerce platform experiences peak traffic during seasonal sales, processing millions of transactions per hour. The database needs to handle these high volumes of concurrent read and write operations with extremely low latency to ensure a smooth customer experience. Data consistency is important for individual transactions but can be relaxed across the entire system for global scale. Which database type is most appropriate for this operational workload?
- AOLAP Database
- BTransactional (OLTP) Database
- CData Warehouse
- DTime Series Database
Show answer & explanationAnswer & explanation
Correct answer: B. Transactional (OLTP) Database
A transactional (OLTP) database is specifically designed for high-volume, concurrent read/write operations with low latency, essential for e-commerce platforms. While consistency is crucial per transaction, these systems often scale globally by sacrificing some global consistency for availability and partition tolerance (BASE properties), fitting the 'relaxed across the entire system' requirement.
Why the other options are wrong
- A. OLAP databases are for analytical processing, not operational transaction handling.
- C. Data warehouses are for analytical queries, not high-volume transactional processing.
- D. Time series databases are for time-stamped data, not general-purpose e-commerce transactions.
Online Transaction Processing (OLTP)
A class of software programs capable of supporting transaction-oriented applications, typically for data entry and retrieval transaction processing.
- Handles high volume of short, atomic transactions
- Optimized for reads and writes
- Emphasizes data integrity and concurrency
Memory trick: OLTP is for 'transactions' happening 'online' right now.