Courseiva
Data Concepts and EnvironmentseasyMultiple ChoiceObjective-mapped

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 its native format and supports schema-on-read, making it ideal for storing unstructured and semi-structured data for future analysis.

  • Data mart

    Why it's wrong here

    A data mart is a subset of a data warehouse focused on a specific business area, requiring structured data.

  • Data warehouse

    Why it's wrong here

    Data warehouses require structured data and predefined schemas, which is not suitable for raw IoT data.

  • Operational database

    Why it's wrong here

    Operational databases are optimized for transactional queries and not designed for storing large volumes of raw data.

About these practice questions

Courseiva writes every DA0-002 question from scratch — 986 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 →

How Courseiva writes practice questions · Editorial policy

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.