DA0-002 Data Concepts and Environments Practice Question
A retail company analyzes customer purchase data to improve inventory management. They store daily transaction records in a relational database and monthly aggregate reports in a data warehouse. Which difference between these storage methods best explains why the warehouse is more suitable for trend analysis?
⚠ Common exam trap
CompTIA often tests the misconception that 'data warehouses only store historical data' (Option D) as the primary reason for trend analysis suitability, but the real differentiator is the workload optimization (OLTP vs. OLAP), not merely the presence of history.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
The database is optimized for write-heavy OLTP, while the warehouse is optimized for read-heavy OLAP.
OLTP databases are optimized for high-frequency write operations (INSERT/UPDATE/DELETE) and ACID compliance, making them ideal for transaction processing but poor for complex analytical queries. In contrast, a data warehouse is optimized for read-heavy OLAP workloads, using columnar storage, pre-aggregated tables, and indexing strategies that enable fast aggregation and trend analysis over large historical datasets. This architectural difference directly supports the retail company's need to analyze purchase trends over time.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
The database uses a star schema while the warehouse uses a normalized schema.
Why it's wrong here
The stem contrasts daily transactional records with monthly aggregates, so the relevant axis is data granularity and subject orientation, not schema design. Star versus normalized schemas describe modelling choices; warehouses commonly use star schemas while operational databases are normalised, which reverses this claim.
- ✗
The database enforces ACID transactions, while the warehouse uses eventual consistency.
Why it's wrong here
Consistency models do not determine analytical suitability; warehouses can also provide ACID guarantees. The distinction is that the database stores granular transactional rows for day-to-day processing, while the warehouse stores aggregated historical data organised for querying trends across periods.
- ✓
The database is optimized for write-heavy OLTP, while the warehouse is optimized for read-heavy OLAP.
Why this is correct
The relational database handles write-heavy OLTP workloads with frequent row-level inserts and updates, while the warehouse uses columnar, read-heavy OLAP designs optimised for scanning and aggregating large historical datasets. That architectural difference is what makes the warehouse suitable for trend analysis.
- ✗
The database stores only current data, while the warehouse stores historical data.
Why it's wrong here
Both store historical data; the operational database retains past transactions too, so currency is not the differentiator. The warehouse holds aggregated, subject-oriented snapshots suited to trend analysis, whereas the database holds row-level current-state records optimised for transaction processing.
Go deeper
Related to this question
About these practice questions
This DA0-002 question is part of Courseiva's 1,004-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DA0-002 practice question is part of Courseiva's free CompTIA certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DA0-002 exam.