DP-900 Describe core data concepts Practice Question
A healthcare company stores patient records in a relational database with fixed columns (PatientID, Name, DOB, BloodType). Medical images such as X-rays are stored as DICOM files. Clinical notes are stored as free-text documents. Which of the following correctly classifies these data types from most structured to least structured?
⚠ Common exam trap
The trap here is that candidates often misclassify DICOM files as fully structured due to their standardized header, overlooking the unstructured binary image payload that makes them semi-structured.
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
✓
Patient records (structured), DICOM files (semi-structured), Clinical notes (unstructured)
Patient records in a fixed-column relational database are structured data because they conform to a rigid schema with defined data types. DICOM files are semi-structured because they contain a structured header with metadata tags (e.g., patient ID, study date) alongside an unstructured binary image payload. Clinical notes as free-text documents are unstructured because they lack a predefined schema or organization, making them difficult to query without natural language processing.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Patient records (structured), DICOM files (structured), Clinical notes (unstructured)
Why it's wrong here
This option correctly identifies patient records as structured because they live in relational tables with immutable columns. However, it mislabels DICOM files as structured: a DICOM file is a container with an ordered set of metadata elements (tags) that vary in presence and can nest, which is characteristic of semi-structured data rather than rows and columns. Clinical notes are correctly classified as unstructured, but the error on DICOM makes the answer wrong.
When this WOULD be correct
If the question defined 'structured data' as any data with a predefined schema or format, and DICOM files were described as having a fixed header format with no free-text components, then option A could be correct.
- ✓
Patient records (structured), DICOM files (semi-structured), Clinical notes (unstructured)
Why this is correct
Patient records in a relational database have a fixed schema of columns and data types, so they are structured. DICOM files contain header fields with standardized metadata tags plus pixel data, which fits the semi-structured category because they have an organized structure but not a rigid tabular schema. Clinical notes are free-form text written by clinicians, lacking any predefined format, so they are unstructured. This combination correctly maps each data type to its storage and query characteristics.
- ✗
Patient records (semi-structured), DICOM files (unstructured), Clinical notes (structured)
Why it's wrong here
This answer inverts all three classifications. Patient records are not semi-structured; they are stored in relational tables with fixed columns and primary keys, making them a textbook example of structured data. DICOM files are not unstructured; they adhere to a standard with explicit metadata tags for describing the image, so they are semi-structured. Clinical notes are not structured; they are free text that cannot be directly queried by relational operators, making them unstructured.
When this WOULD be correct
If the question asked to classify from least structured to most structured, or if patient records were described as having variable fields (e.g., XML or JSON), then patient records could be semi-structured, DICOM files unstructured, and clinical notes structured (e.g., if they followed a template with fixed fields).
- ✗
Patient records (unstructured), DICOM files (semi-structured), Clinical notes (structured)
Why it's wrong here
This option gets DICOM right as semi-structured because of its tag-based metadata, but it fails on the other two. Patient records are not unstructured: a relational table defines named columns and constraints, which is the definition of structured data. Clinical notes are not structured; they are dictated or typed free text without an enforced model. Since two-thirds of the classifications are wrong, this answer cannot be correct.
When this WOULD be correct
This option would be correct if the question asked for classification from least structured to most structured, and if patient records were described as having variable fields (e.g., NoSQL documents) making them semi-structured, DICOM files were considered unstructured (ignoring metadata), and clinical notes were structured (e.g., templated forms).
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.
✓Patient records (structured), DICOM files (semi-structured), Clinical notes (unstructured)Correct answer▾
Why this is correct
Patient records in a relational database have a fixed schema of columns and data types, so they are structured. DICOM files contain header fields with standardized metadata tags plus pixel data, which fits the semi-structured category because they have an organized structure but not a rigid tabular schema. Clinical notes are free-form text written by clinicians, lacking any predefined format, so they are unstructured. This combination correctly maps each data type to its storage and query characteristics.
✗Patient records (structured), DICOM files (structured), Clinical notes (unstructured)Wrong answer — click to see why▾
Why this is wrong here
DICOM files are semi-structured because they contain a structured header (metadata) and unstructured pixel data; classifying them as structured is incorrect.
★ When this WOULD be the correct answer
If the question defined 'structured data' as any data with a predefined schema or format, and DICOM files were described as having a fixed header format with no free-text components, then option A could be correct.
Why candidates choose this
Candidates may assume that any file with a standard format (like DICOM) is structured, overlooking the distinction between structured metadata and unstructured binary image data.
✗Patient records (semi-structured), DICOM files (unstructured), Clinical notes (structured)Wrong answer — click to see why▾
Why this is wrong here
Patient records with fixed columns are structured, not semi-structured. DICOM files contain metadata tags and image data, making them semi-structured, not unstructured. Clinical notes are free-text, which is unstructured, not structured.
★ When this WOULD be the correct answer
If the question asked to classify from least structured to most structured, or if patient records were described as having variable fields (e.g., XML or JSON), then patient records could be semi-structured, DICOM files unstructured, and clinical notes structured (e.g., if they followed a template with fixed fields).
Why candidates choose this
Candidates may confuse DICOM files as unstructured because they are binary image files, overlooking the embedded metadata that gives them structure. They might also incorrectly assume that any database table is semi-structured, misunderstanding the fixed schema nature of relational tables.
✗Patient records (unstructured), DICOM files (semi-structured), Clinical notes (structured)Wrong answer — click to see why▾
Why this is wrong here
Patient records with fixed columns are structured, not unstructured. Clinical notes are free-text and unstructured, not structured. DICOM files are semi-structured because they contain metadata tags alongside binary image data, not semi-structured in the wrong order.
★ When this WOULD be the correct answer
This option would be correct if the question asked for classification from least structured to most structured, and if patient records were described as having variable fields (e.g., NoSQL documents) making them semi-structured, DICOM files were considered unstructured (ignoring metadata), and clinical notes were structured (e.g., templated forms).
Why candidates choose this
Candidates may confuse DICOM files as unstructured because they contain binary image data, overlooking the embedded metadata that gives them structure. They might also misclassify clinical notes as structured if they think of templates or forms, but free-text notes are inherently unstructured.
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
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.
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
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.