Data in a data warehouse can be differentiated from data in a database in that the former ____.
A)captures raw transaction data
B)is used for capturing and managing transactions
C)comes from a variety of sources
D)only keeps recent activity in memory

Question

Quizplus · Accepted Answer

Data in a data warehouse comes from a variety of sources, including databases, flat files, and other external sources. This is unlike data in a database, which is typically managed within a single application or system and is not designed to support complex analytics or reporting. Data warehouses are specifically designed to store large amounts of historical data and provide a single source of truth for decision-making across an organization.

Data in a Data Warehouse Can Be Differentiated from Data