DP-900 Describe core data concepts Practice Question
A company stores customer data in a relational table with columns CustomerID, FullName, and Email. They also store product descriptions as JSON documents with varying fields, and product images as JPEG files. Which of the following correctly classifies these data types from most structured to least structured?
⚠ Common exam trap
Watch out — candidates often confuse semi-structured (JSON) with unstructured (JPEG) because both lack a fixed schema, but JSON has inherent key-value structure that databases can query, whereas JPEG is purely binary with no queryable structure.
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
The customer data in a relational table with fixed columns (CustomerID, FullName, Email) is structured because it has a rigid schema and defined data types. The JSON documents for product descriptions are semi-structured because they use key-value pairs with flexible fields but still have metadata (tags, keys) that provide organization. The JPEG product images are unstructured because they are binary blobs with no inherent schema or metadata that the database can query directly. This ordering from most to least structured matches option A.
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
Correct. A relational table is fully structured because it enforces a fixed schema: predefined columns, data types, and constraints that make every row uniformly queryable. JSON is semi-structured because it uses flexible key-value pairs and nesting that organize data but do not require the same rigid schema. JPEG images are unstructured because their binary pixel encoding has no inherent schema or fields that a database can query directly, so the correct order is structured, semi-structured, unstructured.
- ✗
Unstructured, semi-structured, structured
Why it's wrong here
Incorrect. This sequence reverses the entire spectrum and incorrectly ranks JPEG images as the most structured. In data governance, 'structuredness' refers to how closely data conforms to a predefined schema or data model, not to visual complexity or file organization. A relational table's rigid schema, data types, and relational constraints make it the most structured, while binary image data has no queryable schema and is therefore least structured, making this answer the exact opposite.
When this WOULD be correct
This option would be correct if the question asked to classify data types from least structured to most structured. For example, 'Which of the following correctly classifies these data types from least structured to most structured?'
- ✗
Semi-structured, structured, unstructured
Why it's wrong here
Incorrect. This order incorrectly claims that semi-structured JSON is more structured than a relational table. Although JSON organizes data with keys, arrays, and nesting, it permits each document to vary in fields and types, lacking the enforced uniformity of tables. A relational table's schema is fixed and validated, giving it a higher degree of structure, so structured must precede semi-structured, with unstructured (images) coming last.
When this WOULD be correct
If the question asked for the order from least structured to most structured, then semi-structured, structured, unstructured would be correct. For example: 'Which order correctly ranks these data types from least structured to most structured?'
- ✗
Structured, unstructured, semi-structured
Why it's wrong here
Incorrect. Placing JPEG images before JSON suggests that image files are more organized than semi-structured documents. While a JPEG has a header and compressed pixel layout, that is a binary file format, not a data model with identifiable fields and relationships. JSON, even with schema variability, exposes named attributes and hierarchical nesting that a database engine can parse and query, so it is more structured than a raw binary image; therefore this ordering is wrong.
When this WOULD be correct
This order would be correct if the question asked for data types ordered from most structured to least structured, but the items were: a relational table (structured), a JSON document (semi-structured), and a plain text file (unstructured). In that case, structured, semi-structured, unstructured would be correct, but here the third item is JPEG (unstructured), not 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
Correct. A relational table is fully structured because it enforces a fixed schema: predefined columns, data types, and constraints that make every row uniformly queryable. JSON is semi-structured because it uses flexible key-value pairs and nesting that organize data but do not require the same rigid schema. JPEG images are unstructured because their binary pixel encoding has no inherent schema or fields that a database can query directly, so the correct order is structured, semi-structured, unstructured.
✗Unstructured, semi-structured, structuredWrong answer — click to see why▾
Why this is wrong here
This option orders data types from unstructured to semi-structured to structured, but the question asks for most structured to least structured. Customer data in a relational table is structured, JSON documents are semi-structured, and JPEG images are unstructured, so the correct order is structured, semi-structured, unstructured.
★ When this WOULD be the correct answer
This option would be correct if the question asked to classify data types from least structured to most structured. For example, 'Which of the following correctly classifies these data types from least structured to most structured?'
Why candidates choose this
Candidates may confuse the direction of ordering (most vs. least structured) or mistakenly think that JSON is more structured than relational tables due to its schema flexibility.
✗Semi-structured, structured, unstructuredWrong answer — click to see why▾
Why this is wrong here
Option C orders semi-structured before structured, but the relational table (structured) is more organized than JSON documents (semi-structured). The correct order from most to least structured is structured, semi-structured, unstructured.
★ When this WOULD be the correct answer
If the question asked for the order from least structured to most structured, then semi-structured, structured, unstructured would be correct. For example: 'Which order correctly ranks these data types from least structured to most structured?'
Why candidates choose this
Candidates may confuse the ordering direction or mistakenly think JSON is more structured than relational tables due to its schema flexibility being perceived as more rigid than it is.
✗Structured, unstructured, semi-structuredWrong answer — click to see why▾
Why this is wrong here
Option D orders structured (relational table) first, then unstructured (JPEG images), then semi-structured (JSON documents). This is incorrect because JSON documents are semi-structured, not unstructured, and they are more structured than JPEG files.
★ When this WOULD be the correct answer
This order would be correct if the question asked for data types ordered from most structured to least structured, but the items were: a relational table (structured), a JSON document (semi-structured), and a plain text file (unstructured). In that case, structured, semi-structured, unstructured would be correct, but here the third item is JPEG (unstructured), not semi-structured.
Why candidates choose this
Candidates may confuse JSON documents as unstructured because they have varying fields, forgetting that JSON has a schema-like structure (key-value pairs) that qualifies as semi-structured.
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
One of 820 original DP-900 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.