DA0-002 Data Concepts and Environments Practice Question
A data architect needs to store raw data from various sources, including social media feeds and log files, for future analysis. The data may be used for machine learning and ad-hoc queries. Which storage solution is most appropriate for storing raw data in its native format?
⚠ Common exam trap
Many exam-takers confuse a data lake with a data warehouse, assuming both are for analytics, but the key distinction is that a data warehouse requires structured, transformed data while a data lake preserves raw, native-format data.
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
✓
Data lake
A data lake is designed to store raw data in its native format, including unstructured and semi-structured data from sources like social media feeds and log files. It supports schema-on-read, making it ideal for future machine learning and ad-hoc queries without requiring upfront transformation. This aligns directly with the requirement to preserve raw data for flexible analysis.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Data lake
Why this is correct
Data lakes store raw data in native formats, allowing flexible schema-on-read.
- ✗
Data mart
Why it's wrong here
A data mart is designed for structured, aggregated data optimised for specific departmental reporting, not for storing raw, unprocessed data from social media feeds and log files. It fails because it requires schema-on-write transformation, which would alter the native format and prevent the flexible, ad-hoc queries and machine learning workloads described in the stem. It is tempting because data marts provide fast, pre-aggregated query performance for business intelligence; they would be correct if the requirement were to serve curated, subject-specific reports to a single department.
- ✗
Relational database
Why it's wrong here
Relational databases require structured data with a fixed schema, not ideal for raw, varied data.
- ✗
Data warehouse
Why it's wrong here
Data warehouses store structured, processed data optimized for analytics, not raw data.
Go deeper
Related to this question
About these practice questions
One of 986 original DA0-002 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.