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.

Question

Quizplus · Accepted Answer

A data warehouse is typically a distinct system that provides storage for data that will be made use of in analysis. It is not the end result of BI processes and operations. While data marts are a subset of a data warehouse, it is not accurate to say that a data warehouse is solely a repository of actionable intelligence obtained from a data mart. Additionally, while a data warehouse is often used in OLAP systems, it is not an integral subsystem of such a system but rather a separate component.

Online Transaction Processing (OLTP)systems Handle a Company's Routine Ongoing Business