DA0-002 Data Concepts and Environments Practice Question
Which of the following best describes a data mart?
⚠ Common exam trap
A common mix-up: candidates confuse data marts with data lakes or ETL tools, as all are related to data warehousing but serve different purposes; candidates might incorrectly choose 'raw, unprocessed data' (data lake) or 'ETL tool' due to familiarity with those terms.
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
✓
A subject-specific subset of a data warehouse
A data mart is a subject-specific subset of a data warehouse, designed to serve the analytical needs of a particular department or business function (e.g., sales, finance, marketing). It contains a focused set of data extracted from the enterprise data warehouse or other sources, optimized for query and reporting by a specific user group. This aligns with the definition of a data mart as a smaller, more specialized version of a data warehouse.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
A repository for raw, unprocessed data
Why it's wrong here
A data mart holds curated, subject-specific data for a department's analytics, not raw unprocessed data. Raw unprocessed data belongs in a data lake or staging area before transformation. This option describes ingestion storage, so it fails the definition the question asks for.
- ✗
An OLTP system for transaction processing
Why it's wrong here
A data mart is an analytical, query-oriented store, whereas an OLTP system handles high-volume transactional inserts and updates. The two serve opposite workloads. This option describes the source system that feeds a data mart, not the mart itself.
- ✓
A subject-specific subset of a data warehouse
Why this is correct
A data mart is a subject-specific subset of a data warehouse, scoped to one department or business function. It inherits warehouse data but serves a narrower analytical audience, distinguishing it from the enterprise-wide warehouse itself.
- ✗
A tool for extract, transform, and load processes
Why it's wrong here
ETL tools move and transform data between systems; they are not repositories. A data mart is the target store holding curated departmental data. Confusing the pipeline with its destination fails the definition, though ETL tooling is correctly chosen when building the load processes that populate a mart.
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 and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official CompTIA exam blueprint
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.