The correct order from most to least structured is relational table, JSON documents, JPEG files. This ordering reflects the fundamental data structure hierarchy tested on the DP-900 exam: structured data enforces a rigid schema with fixed columns and data types, as seen in the relational table with CustomerID, FirstName, LastName, and Email; semi-structured data like JSON documents uses key-value pairs but allows varying fields such as optional metadata; and unstructured data like JPEG files has no internal schema or queryable organization. On the Microsoft Azure Data Fundamentals exam, this concept appears in questions about data storage options—relational tables in Azure SQL Database, JSON in Azure Cosmos DB, and binary files in Azure Blob Storage. A common trap is confusing JSON as unstructured because it lacks a fixed schema, but it remains semi-structured due to its inherent key-value structure. Remember the memory tip: “Rigid, Flexible, Formless”—relational is rigid, JSON is flexible, and JPEG is formless.
DP-900 Describe core data concepts Practice Question
This DP-900 practice question tests your understanding of describe core data concepts. Read the scenario carefully and evaluate each option against the stated constraints before committing to an answer. A key principle to apply: structured data conforms to a fixed schema (e.g., relational tables).. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.
A company stores customer data in a relational table with fixed columns: CustomerID (integer), FirstName (string), LastName (string), Email (string). They also store product images as JPEG files, and customer feedback as JSON documents that may contain varying fields such as rating, comment, and optional metadata. Which of the following correctly orders these data types from most structured to least structured?
Clue words in this question
Noticing these words before you look at the options changes how you read each choice.
Clue: "least"
Why it matters: You want the option with minimum overhead, fewest steps, or lowest impact — not the most feature-rich or comprehensive answer.
Why wrong: This order is incorrect. JSON documents are semi-structured, which is less structured than a relational table.
B
Relational table, JSON documents, JPEG files
The relational table has a fixed schema (structured). JSON documents have a flexible schema (semi-structured). JPEG files have no schema (unstructured). This is the correct ordering.
C
JPEG files, JSON documents, relational table
Why wrong: This order is reversed. JPEG files are the least structured, not the most.
D
Relational table, JPEG files, JSON documents
Why wrong: This places JPEG files (unstructured) before JSON documents (semi-structured). JSON has some structure (fields and values), so it is more structured than raw binary data.
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Relational table, JSON documents, JPEG files
The relational table is the most structured because it enforces a fixed schema with predefined columns and data types (e.g., CustomerID integer, FirstName string). JSON documents are semi-structured: they have a flexible schema where fields like rating and comment can vary per document, but they still provide key-value organization. JPEG files are unstructured binary data with no internal schema or queryable structure, making them the least structured.
Key principle: Structured data conforms to a fixed schema (e.g., relational tables).
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
✗
JSON documents, relational table, JPEG files
Why it's wrong here
This order is incorrect. JSON documents are semi-structured, which is less structured than a relational table.
✓
Relational table, JSON documents, JPEG files
Why this is correct
The relational table has a fixed schema (structured). JSON documents have a flexible schema (semi-structured). JPEG files have no schema (unstructured). This is the correct ordering.
Clue confirmation
The clue word "least" in the question point toward this answer.
Related concept
Structured data conforms to a fixed schema (e.g., relational tables).
✗
JPEG files, JSON documents, relational table
Why it's wrong here
This order is reversed. JPEG files are the least structured, not the most.
✗
Relational table, JPEG files, JSON documents
Why it's wrong here
This places JPEG files (unstructured) before JSON documents (semi-structured). JSON has some structure (fields and values), so it is more structured than raw binary data.
Common exam traps
Common exam trap: answer the scenario, not the keyword
The trap here is that candidates often confuse semi-structured data (JSON) with unstructured data (JPEG), mistakenly thinking JSON is unstructured because its fields can vary, when in fact it retains a key-value structure that makes it semi-structured.
Detailed technical explanation
How to think about this question
In Azure, relational tables (e.g., in Azure SQL Database) enforce ACID properties and use a fixed schema defined by CREATE TABLE statements. JSON documents (e.g., in Azure Cosmos DB) use a flexible schema model where each document can have different fields, but they still conform to a key-value or document structure. JPEG files are stored as binary large objects (BLOBs) in Azure Blob Storage, with no inherent structure beyond the file header; they require external applications to interpret the pixel data.
KKey Concepts to Remember
Structured data conforms to a fixed schema (e.g., relational tables).
Semi-structured data has a flexible schema (e.g., JSON, XML).
Unstructured data lacks a predefined schema (e.g., images, audio, video).
Relational databases are designed for structured data.
TExam Day Tips
→Watch for words such as best, first, most likely and least administrative effort.
→Review why wrong options are wrong, not only why the correct option is correct.
Key takeaway
Structured data conforms to a fixed schema (e.g., relational tables).
Real-world example
How this comes up in practice
A cloud solutions architect for a retail company is evaluating services for a new workload. The correct answer here reflects best practice for the specific scenario described — not a general cloud recommendation. Structured data conforms to a fixed schema (e.g., relational tables). Cloud exam questions reward reading the constraint carefully: the same technology can be right or wrong depending on the use case.
Related glossary terms
Concepts from this question explained
These glossary pages explain the core terms tested in this DP-900 question in full detail.
Review structured data conforms to a fixed schema (e.g., relational tables)., then practise related DP-900 questions on the same topic to reinforce the concept.
Describe core data concepts — This question tests Describe core data concepts — Structured data conforms to a fixed schema (e.g., relational tables)..
What is the correct answer to this question?
The correct answer is: Relational table, JSON documents, JPEG files — The relational table is the most structured because it enforces a fixed schema with predefined columns and data types (e.g., CustomerID integer, FirstName string). JSON documents are semi-structured: they have a flexible schema where fields like rating and comment can vary per document, but they still provide key-value organization. JPEG files are unstructured binary data with no internal schema or queryable structure, making them the least structured.
What should I do if I get this DP-900 question wrong?
Review structured data conforms to a fixed schema (e.g., relational tables)., then practise related DP-900 questions on the same topic to reinforce the concept.
Are there clue words in this question I should notice?
Yes — watch for: "least". You want the option with minimum overhead, fewest steps, or lowest impact — not the most feature-rich or comprehensive answer.
What is the key concept behind this question?
Structured data conforms to a fixed schema (e.g., relational tables).
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. A company stores customer order data in a relational database table with columns like OrderID, CustomerID, and OrderDate. They also store product images as JPEG files, and customer feedback as JSON documents with varying fields. Which of the following correctly orders these data types from most structured to least structured?
Why B: Relational tables enforce a fixed schema with rows and columns, making them the most structured. JSON documents have a flexible schema with varying fields, placing them in the middle. JPEG files are binary blobs with no inherent structure for querying, making them the least structured. Option B correctly orders these from most structured (relational table) to least structured (JPEG files).
Variation 2. 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?
easy
✓ A.Structured, semi-structured, unstructured
B.Semi-structured, structured, unstructured
C.Unstructured, semi-structured, structured
D.Structured, unstructured, semi-structured
Why A: 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.
Variation 3. A retail company stores customer data in three formats: a relational database table with fixed columns for CustomerID, Name, and Email; customer feedback as JSON documents with varying fields such as rating and comment; and product images as JPEG files. Which of the following correctly classifies these data types from most structured to least structured?
easy
A.JSON documents, relational table, image files
✓ B.Relational table, JSON documents, image files
C.Image files, JSON documents, relational table
D.Relational table, image files, JSON documents
Why B: Option B is correct because relational tables enforce a fixed schema with defined columns and data types, making them the most structured. JSON documents are semi-structured, allowing varying fields and flexible schemas, while image files are unstructured binary data with no inherent schema. This ordering from most to least structured aligns with the core data classification concept in the DP-900 exam.
Variation 4. A company stores customer data in three formats: a relational table with fixed columns for CustomerID, Name, and Email; product reviews stored as JSON documents with varying fields such as rating and comment; and product demonstration videos in MP4 format. Which of the following correctly lists these data types from most structured to least structured?
easy
A.Relational table, MP4 videos, JSON documents
B.JSON documents, relational table, MP4 videos
✓ C.Relational table, JSON documents, MP4 videos
D.MP4 videos, JSON documents, relational table
Why C: Option C is correct because data structuredness is determined by schema rigidity. A relational table has a fixed schema with predefined columns (CustomerID, Name, Email), making it the most structured. JSON documents have a flexible schema where fields like rating and comment can vary per document, placing them in the semi-structured category. MP4 videos are unstructured binary data with no inherent schema, making them the least structured.
Last reviewed: Jun 11, 2026
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
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.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.