How does a data warehouse support business intelligence?

• A. By limiting access to data
• B. By enhancing real-time transactions
• C. By consolidating data for analysis and reporting
• D. By focusing on unstructured data

Answer: (C)

A data warehouse plays a pivotal role in supporting business intelligence by consolidating data for analysis and reporting. This centralized repository gathers data from various sources, transforming and organizing it in a way that makes it more accessible and useful for decision-makers within an organization.

By integrating disparate datasets from different departments, such as sales, finance, and marketing, a data warehouse allows analysts to conduct comprehensive analyses and generate insights that cover the entire business. This holistic view is essential for informed decision-making, strategic planning, and performance tracking, enabling organizations to identify trends and opportunities, ultimately improving efficiency and competitiveness.

In contrast, limiting access to data would hinder decision-making and analysis. Enhancing real-time transactions pertains more to operational databases than to data warehouses, which typically focus on historical data. Similarly, while unstructured data is valuable, the primary function of a data warehouse is to handle structured data for reporting and analysis, emphasizing the importance of structured, consolidated information as a foundation for effective business intelligence.