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
Structured data is organized into predefined schemas, such as tables with rows and columns, which enforce a consistent data format and relationships. This rigid structure allows structured data to be easily queried using SQL, as SQL is designed to operate on relational database management systems (RDBMS) that rely on these schemas. Option C is correct because a predefined schema is a defining characteristic of structured data, enabling efficient storage, retrieval, and integrity constraints.
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 characteristic of unstructured data, not structured data.
- ✗
Data lacks a fixed format
Why it's wrong here
Lacking a fixed format is a characteristic of unstructured data.
- ✓
Data is stored in predefined schemas
Why this is correct
Structured data follows a predefined schema, such as tables in a relational database.
- ✗
Data often requires NoSQL databases for storage
Why it's wrong here
NoSQL databases are typically used for unstructured or semi-structured data, not structured data.
- ✓
Data can be easily queried using SQL
Why this is correct
Structured data is often stored in relational databases, which are queried using SQL.
Go deeper
Related to this question
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 →
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.