Structured, Semi-Structured, Unstructured Data Types
A healthcare provider stores patient admission data in a relational database table with columns for PatientID, Name, and AdmissionDate. Progress notes are stored as free-text documents. Lab results are stored as XML files that contain varying fields depending on the test type. Which of the following correctly categorizes these three data types in order: relational table, progress notes, lab results?
Quick Answer
The answer is structured, unstructured, semi-structured. This categorization hinges on schema enforcement: structured data, like the relational table with fixed columns for PatientID, Name, and AdmissionDate, adheres to a rigid, predefined schema; unstructured data, such as free-text progress notes, lacks any formal structure; and semi-structured data, exemplified by XML lab results with tags and varying fields, possesses organizational metadata without a fixed schema. On the Microsoft Azure Data Fundamentals DP-900 exam, this question tests your ability to classify data types based on their format and schema flexibility, a core concept for Azure data storage solutions. A common trap is mistaking XML or JSON for structured data because they look organized, but remember: if the fields can vary between records, it is semi-structured. For a quick memory tip, think of a filing cabinet: structured is a labeled folder with slots, unstructured is a pile of papers, and semi-structured is a folder with sticky notes that change per document.
⚠ Common exam trap
Watch out — candidates often confuse semi-structured data (like XML with varying fields) with unstructured data, or they misorder the three types by not recognizing that a relational table is always structured and free-text is always 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
✓
Structured, Unstructured, Semi-structured
The relational table with PatientID, Name, and AdmissionDate enforces a fixed schema with defined data types, making it structured data. Progress notes as free-text documents have no predefined structure or schema, classifying them as unstructured data. Lab results in XML files use tags to organize data but allow varying fields per test type, which is the hallmark of semi-structured data. Option A correctly maps these in order: structured, unstructured, semi-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.
- ✓
Structured, Unstructured, Semi-structured
Why this is correct
The relational table has a fixed schema (structured). Free-text progress notes have no schema (unstructured). XML files have tags and can vary, making them semi-structured. This is correct.
- ✗
Structured, Semi-structured, Unstructured
Why it's wrong here
This reverses the last two. Progress notes are not semi-structured; they are unstructured. Lab results in XML are semi-structured, not unstructured.
When this WOULD be correct
If the question had progress notes as structured fields (e.g., coded entries) and lab results as free-text reports, then the order would be Structured, Semi-structured, Unstructured.
- ✗
Semi-structured, Unstructured, Structured
Why it's wrong here
The relational table is not semi-structured; it is structured. Progress notes are correctly unstructured, but lab results are semi-structured, not structured.
When this WOULD be correct
If the question asked for 'relational table, lab results, progress notes' and lab results were described as free-text documents while progress notes were XML files, then the order would be: structured, unstructured, semi-structured.
- ✗
Unstructured, Structured, Semi-structured
Why it's wrong here
The relational table is not unstructured; it is structured. Progress notes are not structured; they are unstructured.
When this WOULD be correct
This option would be correct if the question asked: 'A healthcare provider stores patient admission data as free-text documents, progress notes in a relational database, and lab results as JSON files. Which order correctly categorizes these data types?' Then the order would be Unstructured (admission data), Structured (progress notes), Semi-structured (lab results).
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, Unstructured, Semi-structuredCorrect answer▾
Why this is correct
The relational table has a fixed schema (structured). Free-text progress notes have no schema (unstructured). XML files have tags and can vary, making them semi-structured. This is correct.
✗Structured, Semi-structured, UnstructuredWrong answer — click to see why▾
Why this is wrong here
Progress notes are free-text, which is unstructured data, not semi-structured. Lab results as XML have a schema and tags, making them semi-structured, not unstructured.
★ When this WOULD be the correct answer
If the question had progress notes as structured fields (e.g., coded entries) and lab results as free-text reports, then the order would be Structured, Semi-structured, Unstructured.
Why candidates choose this
Candidates may confuse free-text documents as semi-structured because they contain some organization (e.g., headings), or mistakenly think XML is unstructured due to varying fields.
✗Semi-structured, Unstructured, StructuredWrong answer — click to see why▾
Why this is wrong here
Lab results (XML) are semi-structured, not unstructured; progress notes (free-text) are unstructured, not semi-structured. The order should be: structured (relational table), unstructured (progress notes), semi-structured (lab results).
★ When this WOULD be the correct answer
If the question asked for 'relational table, lab results, progress notes' and lab results were described as free-text documents while progress notes were XML files, then the order would be: structured, unstructured, semi-structured.
Why candidates choose this
Candidates may confuse semi-structured data (like XML) with unstructured data, or misorder the types due to not carefully reading the sequence of data types in the question.
✗Unstructured, Structured, Semi-structuredWrong answer — click to see why▾
Why this is wrong here
The option D (Unstructured, Structured, Semi-structured) is wrong because it misorders the data types: patient admission data (relational table) is structured, progress notes (free-text) are unstructured, and lab results (XML) are semi-structured.
★ When this WOULD be the correct answer
This option would be correct if the question asked: 'A healthcare provider stores patient admission data as free-text documents, progress notes in a relational database, and lab results as JSON files. Which order correctly categorizes these data types?' Then the order would be Unstructured (admission data), Structured (progress notes), Semi-structured (lab results).
Why candidates choose this
Candidates may confuse the data types, thinking that free-text progress notes are semi-structured or that XML lab results are unstructured, leading to a misordering that seems plausible but is incorrect.
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
Relational database
A relational database organizes data into tables with rows and columns, where each table relates to others using unique keys, allowing efficient storage, retrieval, and manipulation of structured information.
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 →
Same concept, more angles
2 more ways this is tested on DP-900
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 names and addresses in a relational table, product descriptions as JSON files, and product images as JPEG files. Which of the following correctly classifies these data types from most structured to least structured?
easy- ✓ A.Structured (customer table), Semi-structured (JSON), Unstructured (JPEG)
- B.Structured (customer table), Unstructured (JSON), Semi-structured (JPEG)
- C.Semi-structured (customer table), Structured (JSON), Unstructured (JPEG)
- D.Unstructured (customer table), Structured (JSON), Semi-structured (JPEG)
Why A: A is correct because structured data (customer table) has a fixed schema with rows and columns, semi-structured data (JSON) uses tags or key-value pairs without a rigid schema, and unstructured data (JPEG) has no predefined structure. The question tests the standard classification hierarchy from most to least structured.
Variation 2. A data analyst receives a dataset containing customer order details stored in a CSV file, a JSON file with product reviews, and a folder of JPEG images of products. Which of the following correctly categorizes these data types from most structured to least structured?
easy- A.CSV → JPEG → JSON
- B.JSON → CSV → JPEG
- ✓ C.CSV → JSON → JPEG
- D.JPEG → JSON → CSV
Why C: CSV files are highly structured with rows and columns defined by a schema, making them the most structured. JSON files are semi-structured, using key-value pairs and nested objects that allow flexibility but lack a fixed schema. JPEG images are unstructured binary data with no inherent schema, so the correct order from most to least structured is CSV → JSON → JPEG, making option C correct.
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.