A hospital system stores patient medical records. Each record includes structured data like patient ID, name, date of birth, and also includes unstructured data like doctor's notes and X-ray images. Which type of data is the doctor's notes?
Trap 1: A
Structured data fits a rigid, predefined schema: each entity is represented by fixed fields such as patient ID, date of birth, or diagnosis code, with strict data types and relationships enforced by tables. A doctor's narrative note is free-form prose that does not map to fixed columns or enforce uniform fields, so it cannot be directly stored as structured data without extensive parsing and data extraction. Even when a note contains recognizable components, the raw record itself lacks the row-and-column organization that defines structured data. Therefore, classifying a doctor's note as structured data is incorrect.
Trap 2: B
Semi-structured data, such as JSON, XML, or CSV files, carries self-describing organizational markers like tags, keys, or hierarchy levels that allow a flexible schema to be inferred. A physician's dictation or typed note is a continuous block of natural language with no embedded metadata, tags, or key-value pairs to delineate distinct data elements. While the note may contain sentences that could be annotated manually or programmatically, the data as stored has no implicit structure imposed by format. Thus, it does not qualify as semi-structured data.
Trap 3: D
Relational data is a specific form of structured data that is organized into tables with rows, columns, primary keys, and foreign keys to enforce relationships and integrity. A doctor's note is a free-text narrative that cannot be decomposed into relational tuples unless its content is extracted into discrete fields like medication, dosage, and diagnosis. The raw text itself does not fit into relations and has no key-based associations or constraints; it exists as an unstructured document rather than a set of tables. Therefore, classifying it as relational data is incorrect.
- A
A. Structured data
Why it fails: Structured data fits a rigid, predefined schema: each entity is represented by fixed fields such as patient ID, date of birth, or diagnosis code, with strict data types and relationships enforced by tables. A doctor's narrative note is free-form prose that does not map to fixed columns or enforce uniform fields, so it cannot be directly stored as structured data without extensive parsing and data extraction. Even when a note contains recognizable components, the raw record itself lacks the row-and-column organization that defines structured data. Therefore, classifying a doctor's note as structured data is incorrect.
- B
B. Semi-structured data
Why it fails: Semi-structured data, such as JSON, XML, or CSV files, carries self-describing organizational markers like tags, keys, or hierarchy levels that allow a flexible schema to be inferred. A physician's dictation or typed note is a continuous block of natural language with no embedded metadata, tags, or key-value pairs to delineate distinct data elements. While the note may contain sentences that could be annotated manually or programmatically, the data as stored has no implicit structure imposed by format. Thus, it does not qualify as semi-structured data.
- C
C. Unstructured data
Unstructured data lacks a predefined data model or schema, and doctor's notes are a classic example because they consist of free-form clinical narrative, abbreviations, and clinical jargon that varies widely among providers. These notes have no fixed fields, no consistent ordering of information, and no format-level markers that would let an application programmatically interpret them without advanced natural language processing. In Azure, such content is commonly stored in Blob Storage or Data Lake as documents or plain text files, which can later be analyzed using AI or search services. This absence of inherent structure makes the record correctly classified as unstructured data.
- D
D. Relational data
Why it fails: Relational data is a specific form of structured data that is organized into tables with rows, columns, primary keys, and foreign keys to enforce relationships and integrity. A doctor's note is a free-text narrative that cannot be decomposed into relational tuples unless its content is extracted into discrete fields like medication, dosage, and diagnosis. The raw text itself does not fit into relations and has no key-based associations or constraints; it exists as an unstructured document rather than a set of tables. Therefore, classifying it as relational data is incorrect.