CompTIA Data+ (DA0-002)Data Concepts and EnvironmentsMedium
A data analytics team is preparing to integrate data from various operational systems, including customer relationship management (CRM), enterprise resource planning (ERP), and point-of-sale (POS) systems. The goal is to create a single, consistent source of truth for historical reporting, trend analysis, and business intelligence, after cleaning and transforming the data. Which data environment is designed for this specific purpose?
- ATransactional Database
- BData Lake
- CNoSQL Database
- DData Warehouse
Show answer & explanationAnswer & explanation
Correct answer: D. Data Warehouse
A data warehouse is specifically designed to integrate and store cleaned, transformed, and structured historical data from multiple operational sources. Its purpose is to support analytical queries, reporting, and business intelligence, providing a consistent 'source of truth'.
Why the other options are wrong
- A. A transactional database is for real-time operational processing, not for integrating historical data from multiple sources for analytics.
- B. A data lake stores raw, untransformed data, which contradicts the requirement for cleaned and transformed data for reporting.
- C. A NoSQL database is a category of flexible databases, but a data warehouse specifically refers to the architectural pattern for integrated analytical data.
Data Warehouse
A centralized repository of integrated data from one or more disparate sources. It stores current and historical data in one single place that is used for creating analytical reports for knowledge workers.
- Stores structured, cleaned, and transformed data.
- Subject-oriented, integrated, time-variant, non-volatile.
- Optimized for read-heavy analytical queries.
- Supports business intelligence, reporting, and trend analysis.
- Follows a schema-on-write approach.
Memory trick: Warehouse is clean, integrated, and ready for reports.