Which statement below about data warehouses and data marts is true?
A)The typical size of a data warehouse is small.
B)Data warehouses may replace the transaction processing databases of an organization.
C)A data warehouse or data mart complements the other databases within the organization by providing support for strategic decision making.
D)Data marts can be used for transaction processing.

Question

Quizplus · Accepted Answer

A data warehouse or data mart is designed to support strategic decision making by providing a centralized repository of data that has been extracted, transformed, and loaded from operational systems. Data marts are typically smaller subsets of a data warehouse that are focused on a specific business function, department, or user group. They are not used for transaction processing but rather for reporting, analysis, and data mining. Data warehouses and data marts do not replace transaction processing databases.

Which Statement Below About Data Warehouses and Data Marts Is