DA0-002 Data Concepts and Environments Practice Question
A company needs to store raw, unprocessed data from IoT sensors for future machine learning experiments. The data is in various formats and schemas are not yet defined. Which storage solution is most appropriate?
⚠ Common exam trap
CompTIA often tests the misconception that 'raw data' belongs in a data warehouse because it is 'data,' but the trap is that data warehouses require structured, processed data with a fixed schema, while a data lake is specifically designed for raw, schema-less data storage.
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 the correct choice because it stores raw, unprocessed data in its native format (structured, semi-structured, or unstructured) without requiring a predefined schema. This aligns perfectly with the need to ingest IoT sensor data in various formats for future machine learning experiments, where schemas are not yet defined. Unlike data warehouses or data marts, a data lake supports schema-on-read, allowing the data to be transformed and queried later as needed.
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
A data lake stores raw data in native formats without requiring a predefined schema, so varied IoT sensor payloads can be landed as-is. Schema-on-read defers structure until analysis, satisfying the undefined-schema, future-machine-learning requirement that a warehouse or relational store cannot meet.
- ✗
Data mart
Why it's wrong here
A data mart holds curated, subject-specific data for a defined business audience, so it presupposes schema and purpose the sensors lack. It would suit departmental reporting on modelled data. Raw, schema-less IoT landing requires a data lake, which stores files without transformation.
- ✗
Data warehouse
Why it's wrong here
A data warehouse enforces schema-on-write, requiring data to be modelled and transformed before loading, which conflicts with undefined schemas and raw formats. It would be correct for structured analytics on cleansed data. The scenario needs schema-on-read storage such as a data lake.
- ✗
Operational database
Why it's wrong here
An operational database serves transactional workloads with fixed schemas and current-state records, so it cannot absorb varied raw sensor formats awaiting future analysis. It would be right for live order or inventory processing. The requirement is a data lake holding raw files until schemas emerge.
Go deeper
Related to this question
About these practice questions
Courseiva writes every DA0-002 question from scratch — 1,004 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
Same concept, more angles
1 more way this is tested on DA0-002
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. A company is designing a data lake to store raw sensor data from IoT devices. The data arrives as JSON objects with varying schemas. Which storage approach is most appropriate?
hard- A.Ingest into a relational database with a predefined schema
- B.Store each JSON object as a separate file in a compressed columnar format
- C.Convert all JSON to Avro with a fixed schema before storing
- ✓ D.Store raw JSON files in a distributed file system and apply schema-on-read
Why D: A data lake is designed to store raw data in its native format, and IoT sensor data with varying schemas is best handled by storing raw JSON files in a distributed file system (e.g., HDFS or Amazon S3). This approach leverages schema-on-read, where the schema is applied at query time rather than at write time, allowing flexibility for heterogeneous JSON objects without data loss or transformation overhead.
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.