DP-900 Describe core data concepts Practice Question
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?
⚠ Common exam trap
Microsoft often tests the misconception that JSON is unstructured because it lacks a fixed schema, but JSON is actually semi-structured due to its self-describing key-value pairs, while binary formats like MP4 are truly unstructured.
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
✓
Relational table, JSON documents, MP4 videos
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.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Relational table, MP4 videos, JSON documents
Why it's wrong here
This ordering correctly identifies the relational table as the most structured option but then misranks the remaining two. JSON documents are semi-structured: they contain explicit field names, nesting, and array structures that a database like Azure Cosmos DB can parse and index natively. MP4 videos are unstructured binary files; extracting meaning from them requires media tools to decode frames and audio, so they must come after JSON in the structure hierarchy, not before it.
When this WOULD be correct
If the question asked to list data types from least structured to most structured, then option A (MP4 videos, JSON documents, relational table) would be correct.
- ✗
JSON documents, relational table, MP4 videos
Why it's wrong here
This option incorrectly promotes JSON documents above relational tables, conflating human-readable organization with schema enforcement. A relational table has a schema imposed by DDL statements before any data is loaded, so every row must conform to the same typed columns and constraints. JSON is semi-structured because it is self-describing but schemaless: fields can vary from document to document, and applications must infer meaning at runtime. Therefore, relational tables are the most structured, and JSON cannot be placed ahead of them.
When this WOULD be correct
If the question asked to list data types from least to most structured, then B (JSON, relational table, MP4) would be correct because MP4 is unstructured, JSON is semi-structured, and relational table is structured.
- ✓
Relational table, JSON documents, MP4 videos
Why this is correct
Relational tables are fully structured because they enforce a strict schema: rows, columns, data types, primary keys, and relationships are defined before data is stored. JSON documents are semi-structured because they use self-describing key-value pairs and nesting, but no fixed schema is required, so different documents can have different fields. MP4 videos are unstructured because they are binary containers for compressed audio and video data, with no field-level metadata that can be directly queried without specialized media-processing tools.
- ✗
MP4 videos, JSON documents, relational table
Why it's wrong here
This sequence reverses the correct order by claiming that MP4 videos are the most structured format. MP4 is a binary container whose internal audiovisual data lacks queryable business attributes; even basic metadata like duration or codec is not exposed as row-column fields that a general-purpose query engine can directly search. Relational tables enforce integrity through primary/foreign keys and typed columns, making them the most structured, while JSON ranks between them and MP4 because it carries field names without requiring a predefined schema.
When this WOULD be correct
If the question asked to list data types from least structured to most structured, then D (MP4 videos, JSON documents, relational table) would be correct.
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.
✓Relational table, JSON documents, MP4 videosCorrect answer▾
Why this is correct
Relational tables are fully structured because they enforce a strict schema: rows, columns, data types, primary keys, and relationships are defined before data is stored. JSON documents are semi-structured because they use self-describing key-value pairs and nesting, but no fixed schema is required, so different documents can have different fields. MP4 videos are unstructured because they are binary containers for compressed audio and video data, with no field-level metadata that can be directly queried without specialized media-processing tools.
✗Relational table, MP4 videos, JSON documentsWrong answer — click to see why▾
Why this is wrong here
MP4 videos are unstructured data, not semi-structured like JSON. The order should be relational table (structured), JSON documents (semi-structured), MP4 videos (unstructured).
★ When this WOULD be the correct answer
If the question asked to list data types from least structured to most structured, then option A (MP4 videos, JSON documents, relational table) would be correct.
Why candidates choose this
Candidates may mistakenly think that JSON is less structured than MP4 because JSON has flexible schema, but MP4 is binary and lacks any inherent structure for querying.
✗JSON documents, relational table, MP4 videosWrong answer — click to see why▾
Why this is wrong here
JSON documents are semi-structured (varying fields), while relational tables are structured (fixed schema). The order from most to least structured should be relational table, JSON documents, then MP4 videos, not JSON first.
★ When this WOULD be the correct answer
If the question asked to list data types from least to most structured, then B (JSON, relational table, MP4) would be correct because MP4 is unstructured, JSON is semi-structured, and relational table is structured.
Why candidates choose this
Candidates may mistakenly think JSON is more structured than relational tables because JSON has a defined syntax, but they overlook that relational tables enforce a fixed schema, making them more structured.
✗MP4 videos, JSON documents, relational tableWrong answer — click to see why▾
Why this is wrong here
MP4 videos are unstructured data, not more structured than JSON documents (semi-structured) or relational tables (structured). The order from most to least structured should be relational table, JSON documents, MP4 videos.
★ When this WOULD be the correct answer
If the question asked to list data types from least structured to most structured, then D (MP4 videos, JSON documents, relational table) would be correct.
Why candidates choose this
Candidates may mistakenly think that because videos are large and complex, they are more structured, or they confuse 'structured' with 'rich in information'.
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?”
Go deeper
Related to this question
Learn chapter
Data Roles and Core Concepts
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.
Key term
Table
A table is a structured collection of data organized into rows and columns, used in databases and spreadsheets to store and manage information efficiently.
About these practice questions
This DP-900 question is part of Courseiva's 820-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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.