Which component of the BI stack stores the transformed data and manages it for higher-level systems?

• A. Metadata, data warehouse, warehouse management
• B. Online Analytical Processing, data mining, querying and reporting
• C. Real Time Access, Reports and Dashboards, Web
• D. Customer, Finance, Operations and Supply Chain

Answer: (A)

The part of the BI stack that stores the transformed data and supports higher-level systems is the data warehouse layer, complemented by governance and administration elements. After data is cleaned and transformed, it needs a centralized, integrated store for use by BI tools, dashboards, and reports—that role is fulfilled by the data warehouse. Metadata describes what the data means, where it came from, and how it should be used, ensuring consistent interpretation across systems. Warehouse management covers the operations, performance tuning, security, and maintenance that keep the data environment reliable for those higher-level systems. So, a set that includes metadata, the data warehouse itself, and warehouse management best represents the storage and management function for downstream analytics. The other groups focus on analysis (OLAP, data mining, querying) or on access/interface layers (Real Time Access, Dashboards, Web) or on business domain areas, rather than on storing and managing the transformed data.