You are using an e-commerce application that reads and writes data to an Azure SQL database. Which processing is this application using?

Question

Options

• ABatch Processing
• BStream Processing
• COnline Transaction Processing (OLTP)
• DOnline Analytical Processing (OLAP)

• A
  3% (1)
• C
  93% (28)
• D
  3% (1)

Explanation

Online Transaction Processing (OLTP) is a category of data processing that refers to the management of transactional data in real-time. OLTP involves transaction-oriented tasks such as inserting, deleting, and updating data in a database. OLTP systems mainly deal with a large number of transactions by a large number of users. Option A is incorrect. Batch processing processes transactions in batch or group, in sequential, non-stop, often simultaneous manner. OLTP systems are preferred to manage and facilitate transaction-oriented applications. Option B is incorrect. Stream processing focuses on the real-time processing of continuous data streams and takes action on a series of data at the time just when the data is created. Option C is Correct. Online Transaction Processing (OLTP) is preferred for transaction-oriented tasks to manage transactional data in real-time, for e-commerce and other applications. Option D is incorrect. Online Analytical Processing (OLAP) involves the use of complex queries for the analysis of aggregated historical data received from the OLTP systems. documentation below from Azure: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-transaction-

No community discussion yet for this question.