DA0-002 Data Concepts and Environments Practice Question
A data analyst is comparing characteristics of structured and unstructured data. Which TWO of the following are characteristics of structured data? (Choose two.)
⚠ Common exam trap
Many exam-takers confuse 'lack of fixed format' (unstructured) with 'flexibility in storage' (NoSQL), leading them to select options B or D, which describe unstructured or semi-structured data, not structured 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 is stored in predefined schemas
Option C is correct because structured data is organized according to a predefined schema—such as tables with defined columns, data types, and relationships—which is the defining trait of structured data in relational systems. Option E is correct because structured data stored in relational tables can be directly queried with SQL, using SELECT, JOIN, WHERE, and other standard statements. The unmarked options do not belong: raw text (A) and lack of a fixed format (B) describe unstructured data such as documents or free-form text, and NoSQL databases (D) are typically used for semi-structured or unstructured data rather than being a characteristic of 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.
- ✗
Data is typically stored as raw text
Why it's wrong here
Raw text is the classic unstructured format, holding no predefined fields or data types, whereas structured data is organised into defined columns with typed values. It is tempting because text can be parsed into structured tables, but the storage format itself remains unstructured until that processing occurs.
- ✗
Data lacks a fixed format
Why it's wrong here
Structured data conforms to a predefined schema of rows and columns, so a fixed format is precisely what defines it; lacking a fixed format describes unstructured data such as free text or media. It is tempting because semi-structured sources like JSON or email headers genuinely blur the boundary, but the stem asks about structured data.
- ✓
Data is stored in predefined schemas
Why this is correct
Structured data conforms to a predefined schema, such as relational tables with declared columns and data types. This enforced organisation is what enables consistent storage, validation and predictable retrieval, distinguishing it from unstructured content like free text or media.
- ✗
Data often requires NoSQL databases for storage
Why it's wrong here
Structured data is stored in relational databases using SQL, where a fixed schema enforces relationships and constraints; NoSQL stores are chosen for schema-less or rapidly varying data. It is tempting because NoSQL databases can hold tabular data, but that is a design preference, not a defining characteristic of structured data.
- ✓
Data can be easily queried using SQL
Why this is correct
Because structured data resides in predefined schemas with fixed columns and types, SQL can reference those fields directly for filtering, joining and aggregation. This queryability is a defining characteristic, unlike unstructured data, which requires indexing or parsing before comparable retrieval.
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 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.