Updating,querying,and presenting data from databases for operational purposes is known as:
A)ETL
B)OLAP
C)OLTP
D)Micro batches

Question

Quizplus · Accepted Answer

OLTP (Online Transaction Processing) is designed for operational purposes where data is regularly updated, queried, and presented. It allows for real-time processing and immediate responses to transactions. ETL (Extract, Transform, Load) is used for loading data from various sources into a data warehouse for analytical purposes, while OLAP (Online Analytical Processing) is used for querying and analyzing data in a data warehouse. Micro batches are a method of processing data in small batches rather than in real-time. Therefore, option C is the best choice for this question.

Updating,querying,and Presenting Data from Databases for Operational Purposes Is Known