In BI terms,operational databases are often referred to as ________.
A) data warehouses
B) online transactional processing systems
C) data matrices
D) online analytical processing systems

Question

Quizplus · Accepted Answer

In BI terms, operational databases are often referred to as online transactional processing systems (OLTP). OLTP systems are used for transactional data processing such as creating, updating, and deleting records in real-time. They are designed primarily for data insertion and retrieval, and their main focus is to ensure data accuracy, consistency, and integrity for the day-to-day operations of a business. Data warehouses, on the other hand, are used for analytical processing and storing historical data to support decision-making. Data matrices and online analytical processing systems (OLAP) are not commonly used terms for operational databases.

In BI Terms,operational Databases Are Often Referred to as ________