A data warehouse is a centralized repository designed to consolidate large volumes of information from multiple operational sources so that users can retrieve, integrate, and analyze the information for managerial decision-making. Customer information may originate from sales transactions, CRM systems, websites, marketing campaigns, customer-service interactions, and other enterprise applications.
Unlike an operational transaction database, a data warehouse is structured primarily for analysis and reporting. It enables organizations to examine customer purchasing patterns, profitability, segmentation, demand trends, product preferences, retention behavior, and other historical relationships across substantial datasets.
A clickstream represents the sequence of actions taken by a user while navigating digital content; it is a type of data rather than the centralized repository itself. A QR code provides a mechanism for accessing digital information but is not an analytical database. A social-media site may supply customer information but does not constitute the organization's centralized analytical repository.
The source material for this question explicitly identifies data warehouse as the centralized database used to house and study extensive consumer information.
Reference Topic: Technology, Analytics and Digital Transformation — Data Warehousing, CRM Analytics, and Customer Information Management.
===============
