DA0-002 Data Concepts and Environments Practice Question
Which of the following data types best describes a JSON file containing customer orders with varying fields per record?
⚠ Common exam trap
Candidates often confuse semi-structured data with unstructured data because both lack a fixed schema; candidates often overlook that JSON's self-describing key-value pairs provide enough structure to separate it from truly unstructured formats like images or free text.
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
✓
Semi-structured data
JSON (JavaScript Object Notation) is a text-based format that uses key-value pairs and nested objects/arrays, providing a flexible schema where each record can have different fields. This self-describing structure—where data carries its own metadata via keys—is the hallmark of semi-structured data. Unlike structured data, it doesn't require a rigid, predefined schema, but unlike unstructured data, it still has an organized, machine-readable format. Therefore, a JSON file with varying fields per record is best classified as semi-structured data.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Unstructured data
Why it's wrong here
JSON carries named keys and nested hierarchy, so it retains machine-readable structure; unstructured data has no predefined data model, such as free text or images. Semi-structured is the accurate classification. Unstructured would be correct for raw email bodies, audio or scanned documents.
- ✗
Structured data
Why it's wrong here
JSON records with differing fields per order are semi-structured: keys are named but the schema varies between records, so no fixed relational table applies. Structured data requires a predefined, uniform schema across every row. Structured storage would be right for fixed-column order extracts loaded into a relational warehouse.
- ✗
Relational data
Why it's wrong here
Relational data requires a fixed schema with consistent columns per row, whereas JSON records with varying fields are schema-less and nested. It is tempting because orders map naturally to tables, and relational modelling is correct once fields are fixed and normalised.
- ✓
Semi-structured data
Why this is correct
JSON stores data as nested key-value pairs without a fixed schema, so each order record can carry different fields. That schema-on-read flexibility is the defining trait of semi-structured data, distinguishing it from rigidly tabular structured data and from unstructured raw text.
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 →
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.