Question

Online transaction processing (OLTP) systems handle a company's routine ongoing business. In contrast, a data warehouse is typically _______________.

A) the end result of BI processes and operations.
B) a repository of actionable intelligence obtained from a data mart.
C) a distinct system that provides storage for data that will be made use of in analysis.
D) an integral subsystem of an online analytical processing (OLAP) system

Answer 1

Online transaction processing (OLTP) systems handle a company's routine ongoing business. In contrast, a data warehouse is typically a distinct system that provides storage for data that will be made use of in analysis.

Step-by-step explanation:

• OLTP (Online Transactional Processing) is a category of data processing that is focused on transaction-oriented tasks. OLTP typically involves inserting, updating, and/or deleting small amounts of data in a database.
• OLTP is an online database modifying system. OLAP is an online database query management system.
• OLTP uses traditional DBMS. OLAP uses the data warehouse
• OLTP mainly deals with large numbers of transactions by a large number of users
• OLTP database systems are commonly used for order entry, financial transactions, customer relationship management and retail sales via the Internet.
• Online Analytical Processing tools enable to analyze multidimensional data interactively from multiple perspectives.