DA0-002 Data Concepts and Environments Practice Question
Which THREE of the following are common characteristics of unstructured data?
⚠ Common exam trap
Test-takers frequently confuse 'unstructured' with 'semi-structured' or assuming that any data stored in a database must be queryable via SQL; candidates often pick 'Easily queried using SQL' because they conflate storage with query capability.
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
✓
Often stored in NoSQL databases or data lakes
Option B is correct because unstructured data, such as documents, media files, and logs, is commonly stored in NoSQL databases (e.g., MongoDB, Cassandra) or data lakes (e.g., Amazon S3, Azure Data Lake) that do not require a fixed relational schema. Option C is correct because unstructured data encompasses heterogeneous formats including free text, images, audio, and video, which cannot be easily decomposed into rows and columns. Option E is correct because unstructured data by definition lacks a predefined schema, meaning there is no fixed data model or rigid structure enforced at write time. Option A is incorrect because SQL querying relies on structured, tabular schemas, which unstructured data does not provide. Option D is incorrect because relational tables are the storage model for structured data, not unstructured 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.
- ✗
Easily queried using SQL
Why it's wrong here
Unstructured data lacks a predefined schema, so it cannot be easily queried with SQL, which requires structured tables and columns. It is tempting because SQL engines can index text or JSON, but that requires prior structuring, so it does not describe unstructured data's native queryability.
- ✓
Often stored in NoSQL databases or data lakes
Why this is correct
NoSQL databases and data lakes both accept data without a predefined relational schema, so they accommodate raw text, media and logs. This satisfies the stem's requirement by naming the storage platforms that handle schema-less content, unlike warehouses requiring structure before loading.
- ✓
Can include text, images, and video
Why this is correct
Unstructured data encompasses varied formats such as free text, images, audio, and video, none of which conform to a fixed tabular structure. This format diversity is a core characteristic, contrasting with structured data's uniform, typed fields.
- ✗
Stored in relational tables
Why it's wrong here
Unstructured data is not stored in relational tables; that is the defining trait of structured data held in rows and columns. It is tempting because databases can hold unstructured content as BLOBs, but the storage model itself remains relational, which contradicts the characteristic being asked for.
- ✓
Lacks a predefined schema
Why this is correct
Unstructured data has no predefined schema, so it cannot be stored in fixed relational tables without prior transformation. This absence of a rigid data model is a defining characteristic, distinguishing it from structured data held in rows and columns.
Quick reference
AWS S3 Storage Class Comparison
| Storage Class | Min Duration | Retrieval | Use Case |
|---|---|---|---|
| S3 Standard | None | Immediate | Frequently accessed data |
| S3 Standard-IA | 30 days | Immediate | Infrequent access, rapid retrieval |
| S3 One Zone-IA | 30 days | Immediate | Non-critical infrequent data |
| S3 Intelligent-Tiering | None | Immediate–hours | Unknown or changing access patterns |
| S3 Glacier Instant | 90 days | Milliseconds | Archive with instant retrieval |
| S3 Glacier Flexible | 90 days | Minutes–hours | Archive, flexible retrieval |
| S3 Glacier Deep Archive | 180 days | Hours | Long-term compliance archive |
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.