DP-900 Describe core data concepts Practice Question
A retail company stores customer data in a relational database table with columns for CustomerID, Name, and Email. Product reviews are stored as JSON documents where each document contains review text and a rating. Product images are stored as binary files in Azure Blob Storage. Which of the following correctly categorizes these data types in order: relational table, JSON documents, binary images?
⚠ Common exam trap
A common mix-up: candidates confuse semi-structured data (like JSON) with unstructured data because JSON appears 'flexible,' but it still has a defined key-value structure, whereas truly unstructured data (binary blobs) has no schema at all.
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
✓
Structured, semi-structured, unstructured
A is correct because relational tables enforce a fixed schema (columns with defined data types), making them structured data. JSON documents have a flexible schema (key-value pairs) but still contain metadata, classifying them as semi-structured. Binary image files in Azure Blob Storage have no inherent structure or schema, making them unstructured data. This matches the order: structured, semi-structured, unstructured.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Structured, semi-structured, unstructured
Why this is correct
Relational database tables are structured because they enforce a fixed schema with defined columns and data types, allowing straightforward SQL queries. JSON is semi-structured since it uses self-describing key-value pairs that can vary from record to record, lacking a rigid schema. Binary image files are unstructured as they contain raw pixel data with no inherent organization or queryable structure, completing the correct classification.
- ✗
Semi-structured, structured, unstructured
Why it's wrong here
This ordering incorrectly classifies the relational table as semi-structured, but relational tables are actually structured because every row must conform to a predefined column layout with strict data types. JSON data is semi-structured, not structured, because its schema is flexible and embedded within each record. The correct sequence should place structured first, then semi-structured, then unstructured.
When this WOULD be correct
If the question asked about a NoSQL key-value store (semi-structured), a relational table (structured), and binary files (unstructured), then the order semi-structured, structured, unstructured would be correct.
- ✗
Unstructured, semi-structured, structured
Why it's wrong here
Labeling the relational database table as unstructured is wrong because structured data is defined by a rigid schema that dictates rows, columns, and data types. Unstructured data, such as binary images, lacks any schema or predictable format. JSON is semi-structured because it offers partial organization through tags and key-value pairs, so the proper order begins with structured, not unstructured.
When this WOULD be correct
If the question asked to categorize the data types in the order: binary images, JSON documents, relational table, then the correct answer would be unstructured, semi-structured, structured (Option C).
- ✗
Structured, unstructured, semi-structured
Why it's wrong here
This option correctly identifies the relational table as structured, but it incorrectly marks JSON as unstructured. JSON is semi-structured because it consists of nested key-value pairs with a flexible schema, unlike the completely schema-less nature of binary image data. The last category, unstructured, should be reserved for images, making the correct sequence structured, semi-structured, unstructured.
When this WOULD be correct
Option D would be correct if the question asked to classify data types in the order: a relational table, a collection of scanned PDF documents (unstructured), and XML files with a schema (semi-structured).
Option-by-option analysis
Why each answer is right or wrong
Understanding why wrong answers are wrong — and when they would be correct — is what separates a 750 score from a 900. The DP-900 exam frequently reuses these exact scenarios with slightly different constraints.
✓Structured, semi-structured, unstructuredCorrect answer▾
Why this is correct
Relational database tables are structured because they enforce a fixed schema with defined columns and data types, allowing straightforward SQL queries. JSON is semi-structured since it uses self-describing key-value pairs that can vary from record to record, lacking a rigid schema. Binary image files are unstructured as they contain raw pixel data with no inherent organization or queryable structure, completing the correct classification.
✗Semi-structured, structured, unstructuredWrong answer — click to see why▾
Why this is wrong here
The relational table (structured) is mislabeled as semi-structured, and the JSON documents (semi-structured) are mislabeled as structured, reversing the correct order.
★ When this WOULD be the correct answer
If the question asked about a NoSQL key-value store (semi-structured), a relational table (structured), and binary files (unstructured), then the order semi-structured, structured, unstructured would be correct.
Why candidates choose this
Candidates may confuse JSON as structured because it has a schema-like format, or mistakenly think relational data is semi-structured due to its tabular nature.
✗Unstructured, semi-structured, structuredWrong answer — click to see why▾
Why this is wrong here
Option C orders the data types as unstructured, semi-structured, structured, but the question asks for the order: relational table (structured), JSON documents (semi-structured), binary images (unstructured). This mismatches the correct sequence.
★ When this WOULD be the correct answer
If the question asked to categorize the data types in the order: binary images, JSON documents, relational table, then the correct answer would be unstructured, semi-structured, structured (Option C).
Why candidates choose this
Candidates may confuse the order of data types or mistakenly think that JSON documents are unstructured because they lack a fixed schema, overlooking that JSON has inherent structure (key-value pairs).
✗Structured, unstructured, semi-structuredWrong answer — click to see why▾
Why this is wrong here
The question orders data types as relational table, JSON documents, binary images. Option D (structured, unstructured, semi-structured) incorrectly classifies JSON documents as unstructured and binary images as semi-structured. In reality, JSON is semi-structured and binary images are unstructured.
★ When this WOULD be the correct answer
Option D would be correct if the question asked to classify data types in the order: a relational table, a collection of scanned PDF documents (unstructured), and XML files with a schema (semi-structured).
Why candidates choose this
Candidates may confuse JSON as unstructured because it lacks a fixed schema, or mistakenly think binary images have some structure (e.g., file headers), leading them to misorder the categories.
Analysis generated from the official DP-900blueprint and verified against question context. The “when correct” sections are what AI assistants cite when candidates ask “what’s the difference between these options?”
Quick reference
Azure Blob Storage Tier Comparison
| Tier | Storage Cost | Retrieval Cost | Latency | Use Case |
|---|---|---|---|---|
| Hot | Highest | Lowest | Immediate | Active data, frequent reads |
| Cool | Lower | Higher | Immediate | Data accessed < once / month |
| Cold | Lower still | Higher | Immediate | Data accessed < once / quarter |
| Archive | Lowest | Highest + rehydration delay | Hours | Long-term compliance retention |
Go deeper
Related to this question
Learn chapter
Data Roles and Core Concepts
Key term
Structured data
Structured data is information that is organized in a predefined format, typically in rows and columns, making it easy to search, process, and analyze by computers.
Key term
Schema
A schema is a blueprint or logical structure that defines how data is organized, stored, and accessed in a database or information system.
About these practice questions
Courseiva writes every DP-900 question from scratch — 820 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 DP-900 practice question is part of Courseiva's free Microsoft 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 DP-900 exam.