You have an e-commerce application that reads and writes data to an Azure SQL database. Which type of processing does the application use?

An e-commerce application's primary function is to process a high volume of concurrent user transactions, such as placing orders, updating customer profiles, and managing inventory. This workload, characterized by frequent, small read and write operations, is defined as Online Transaction Processing (OLTP). Relational database systems like Azure SQL Database are specifically designed and optimized to handle these types of mission-critical transactional workloads efficiently and reliably.

A. stream processing: This is incorrect because stream processing involves analyzing continuous, real-time data flows, not handling discrete, atomic user transactions like placing an order.

B. batch processing: This is incorrect as it deals with processing large volumes of data at scheduled intervals, which is contrary to the immediate, real-time nature of e-commerce transactions.

C. Online Analytical Processing (OLAP): This is incorrect because OLAP systems are designed for complex queries and analysis on large historical datasets for business intelligence, not for processing live operational transactions.

---

1. Microsoft Learn, DP-900: Describe core data concepts. In the "Explore transactional data processing" unit, it states, "Online Transactional Processing (OLTP) systems are used to support business applications that process transactions... Common examples of applications that use an OLTP system include order entry systems, retail sales systems, and financial transaction systems." This directly aligns with the e-commerce scenario.

Source: Microsoft Learn, "Explore transactional data processing", Module: "Describe core data concepts".

2. Microsoft Learn, What is Azure SQL Database? The official documentation describes Azure SQL Database as a "fully managed relational database service built for the cloud" and highlights its use for "mission-critical applications" that require high performance for transactional processing.

Source: Microsoft Azure Documentation, "What is Azure SQL Database?", Overview section.

3. Silberschatz, A., Korth, H. F., & Sudarshan, S. (2020). Database System Concepts (7th ed.). University-level database textbooks define OLTP as being characterized by a large number of short online transactions (INSERT, UPDATE, DELETE). The e-commerce application described fits this definition perfectly.

Source: Chapter 1, Section 1.12 "Application Architectures".