CompTIA Data+ (DA0-002)Data Concepts and EnvironmentsMedium
A data analytics team is preparing to integrate data from various operational systems, including CRM, ERP, and marketing automation platforms, into a central repository for historical reporting and business intelligence. The goal is to provide a unified, consistent view of the business for strategic decision-making. Which data environment is BEST suited for this purpose?
- AData Warehouse
- BData Lake
- CTransactional Database
- DOperational Data Store (ODS)
Show answer & explanationAnswer & explanation
Correct answer: A. Data Warehouse
A data warehouse is specifically designed for integrating data from multiple disparate sources into a consistent, historical view for reporting and analytical purposes. It undergoes an ETL process to ensure data quality and structure suitable for business intelligence and strategic decision-making.
Why the other options are wrong
- B. A data lake stores raw, unstructured data and is not optimized for immediate, structured historical reporting.
- C. A transactional database is for real-time operations, not for historical, integrated analytical reporting.
- D. An ODS serves as an intermediary for operational reporting and near-real-time data, but not typically for comprehensive historical BI.
Data Warehouse
A large, central repository that stores integrated, historical data from multiple sources, optimized for querying and analysis rather than transaction processing. It supports business intelligence activities.
- Stores historical and integrated data.
- Optimized for analytical queries and reporting.
- Data is typically structured and cleaned (ETL/ELT process).
Memory trick: Warehouse is for wisdom, lake is for raw, transactional is for daily, ODS is near-real-time raw.