What is a data warehouse?

What is a data warehouse?

• A. A central repository for integrated data from multiple sources used for reporting and analytics.
• B. A plan for data cleansing and deduplication.
• C. A method for encrypting data during transmission.
• D. A set of policies governing access to data.

Answer: (C)

A data warehouse is a central repository that brings together data from multiple sources, cleans and consolidates it, and stores it in a way that supports reporting and analytics. It is designed for querying and analyzing large historical datasets, so you can run trends, BI dashboards, and decision-support analyses across the organization. The data are typically transformed during the loading process (ETL/ELT) to ensure consistent definitions and formats, making it easier to compare and analyze data from different systems. The other descriptions describe important data activities or controls but not what a data warehouse is. A plan for data cleansing and deduplication refers to data quality processes, encryption during transmission relates to data security in transit, and policies governing access pertain to data governance and access control.

A data warehouse is a central repository that brings together data from multiple sources, cleans and consolidates it, and stores it in a way that supports reporting and analytics. It is designed for querying and analyzing large historical datasets, so you can run trends, BI dashboards, and decision-support analyses across the organization. The data are typically transformed during the loading process (ETL/ELT) to ensure consistent definitions and formats, making it easier to compare and analyze data from different systems.

The other descriptions describe important data activities or controls but not what a data warehouse is. A plan for data cleansing and deduplication refers to data quality processes, encryption during transmission relates to data security in transit, and policies governing access pertain to data governance and access control.