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
Incorrect: Warehouses typically use dimensional schemas like star, not normalized.
- ✗
The database enforces ACID transactions, while the warehouse uses eventual consistency.
Why it's wrong here
Incorrect: Warehouses can also enforce ACID if needed.
- ✓
The database is optimized for write-heavy OLTP, while the warehouse is optimized for read-heavy OLAP.
Why this is correct
Correct: OLTP supports many writes; OLAP supports complex reads.
- ✗
The database stores only current data, while the warehouse stores historical data.
Why it's wrong here
Incorrect: Databases can store historical data, but warehouses are designed for it.
Go deeper
Related to this question
About these practice questions
This DA0-002 question is part of Courseiva's 986-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.