DA0-002 Data Concepts and Environments Practice Question
A data analyst receives a file with the extension .json. This file contains product information with attributes that vary between records. How should this file be classified?
⚠ Common exam trap
Test-takers frequently confuse 'structured data' with any data that has a format or organization, forgetting that structured data specifically requires a fixed, predefined schema enforced at write time, unlike JSON's flexible schema-on-read approach.
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
A JSON file with varying attributes per record is a classic example of semi-structured data. Unlike strictly structured data (e.g., a relational table with fixed columns), JSON allows each object to have a different set of key-value pairs, making it schema-flexible. This self-describing nature, where metadata is embedded within the data itself, is the defining characteristic of semi-structured formats.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Semi-structured data
Why this is correct
JSON stores data in key-value pairs with a defined syntax but no rigid schema, so attributes can vary between records. That self-describing yet non-tabular structure is the defining characteristic of semi-structured data, distinguishing it from structured relational tables and unstructured raw content.
- ✗
Structured data
Why it's wrong here
JSON records with attributes that vary between records lack the fixed schema and uniform fields structured data requires. It is tempting because JSON's key-value pairs and tabular appearance suggest rigid organisation, and structured data would be correct for a fixed-schema file such as CSV with consistent columns.
- ✗
Transactional data
Why it's wrong here
Transactional data describes records generated by business events such as sales or payments, not a file format classification. It is tempting because product information often originates in transactional systems, and transactional data would be correct when classifying records by their business origin rather than structure.
- ✗
Unstructured data
Why it's wrong here
JSON stores text in a defined syntax with named keys and values, so it retains machine-readable organisation rather than being unstructured. It is tempting because variable attributes suggest free-form content, and unstructured data would be correct for files such as images, audio or raw text.
Go deeper
Related to this question
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 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.