DP-900 Describe core data concepts Practice Question
A logistics company stores shipping waybill data as JSON documents. Each document contains fields like 'shipmentId', 'destination', and 'items', but the number of items and the fields within each item can vary between shipments. Which category best describes this type of data?
⚠ Common exam trap
It's easy for candidates to confuse 'semi-structured' with 'unstructured' because JSON appears flexible, but JSON is still structured with key-value pairs, unlike truly unstructured data like audio or video files.
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
✓
Semi-structured data
JSON documents with varying fields and nested structures like 'items' that differ between shipments are a classic example of semi-structured data. Unlike structured data with a fixed schema, semi-structured data uses tags or markers (like JSON key-value pairs) to separate data elements, allowing for flexibility in the number and type of fields per record. This aligns with the DP-900 definition of semi-structured data, which includes formats such as JSON, XML, and Parquet.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Operational data
Why it's wrong here
Operational data refers to data that supports real-time business functions such as order processing, shipment tracking, or inventory updates, and it is classified by its role in daily operations rather than its structural format. While shipping waybills are certainly operational in nature, the question asks about the data's intrinsic format as stored in JSON, not how it is used. Therefore, this option misidentifies the classification axis—format versus purpose—and is incorrect.
When this WOULD be correct
A question asks: 'Which type of data is generated from daily business transactions, such as sales orders or shipping records?' Operational data would be the correct answer because it describes data used for routine business activities.
- ✓
Semi-structured data
Why this is correct
JSON documents consist of key-value pairs, nested objects, and arrays, but each waybill may have a different set of fields—some optional, some nested. This self-describing format provides inherent organization through keys and hierarchical structure, yet it does not enforce a rigid, predefined schema. That combination of organizational properties without a fixed tabular schema is the defining characteristic of semi-structured data, which is why this is the correct classification.
- ✗
Unstructured data
Why it's wrong here
Unstructured data has no predefined internal structure or machine-readable organization, such as raw image files, audio recordings, and free-form text bodies. JSON, by contrast, explicitly structures data using named keys and values that a parser can traverse programmatically, giving it clear syntactic organization. Because the waybills carry inherent structural metadata, calling them unstructured ignores the very nature of the JSON format and is therefore incorrect.
When this WOULD be correct
A question describing data such as images, videos, audio files, or free-form text documents with no inherent structure or schema. For example: 'A company stores customer support chat logs as plain text files with no formatting. Which data category?'
- ✗
Structured data
Why it's wrong here
Structured data is tightly organized into rows and columns within a relational schema or a fixed field layout, where every record is required to have the same columns and data types. JSON waybills can omit fields, include nested objects, and vary in shape across documents, which violates the strict schema-on-write requirement of structured data. Even if some waybills share common keys, the overall flexibility inherent in JSON prevents it from being considered structured.
When this WOULD be correct
A question describing data stored in a relational database table with predefined columns (e.g., customer ID, name, address) where every row has the same columns and data types would make structured data the correct answer.
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.
✓Semi-structured dataCorrect answer▾
Why this is correct
JSON documents consist of key-value pairs, nested objects, and arrays, but each waybill may have a different set of fields—some optional, some nested. This self-describing format provides inherent organization through keys and hierarchical structure, yet it does not enforce a rigid, predefined schema. That combination of organizational properties without a fixed tabular schema is the defining characteristic of semi-structured data, which is why this is the correct classification.
✗Operational dataWrong answer — click to see why▾
Why this is wrong here
Operational data refers to data used in day-to-day business operations, not a data format category. The question asks about data structure (structured, semi-structured, unstructured), not its purpose.
★ When this WOULD be the correct answer
A question asks: 'Which type of data is generated from daily business transactions, such as sales orders or shipping records?' Operational data would be the correct answer because it describes data used for routine business activities.
Why candidates choose this
Candidates may confuse the term 'operational' with the data's role in logistics operations, mistakenly thinking it describes the data format rather than its business use.
✗Unstructured dataWrong answer — click to see why▾
Why this is wrong here
Unstructured data lacks a predefined data model or schema, but JSON documents have a structure with fields like 'shipmentId', 'destination', and 'items', even if fields vary. The data is semi-structured because it uses tags and keys to organize data, not completely unstructured.
★ When this WOULD be the correct answer
A question describing data such as images, videos, audio files, or free-form text documents with no inherent structure or schema. For example: 'A company stores customer support chat logs as plain text files with no formatting. Which data category?'
Why candidates choose this
Candidates may confuse 'unstructured' with 'flexible structure' because JSON allows varying fields, leading them to think it's unstructured. They overlook that JSON still has a schema (key-value pairs) and is categorized as semi-structured.
✗Structured dataWrong answer — click to see why▾
Why this is wrong here
Structured data requires a fixed schema with consistent fields and data types, but the JSON documents here have varying fields and nested structures, making them semi-structured.
★ When this WOULD be the correct answer
A question describing data stored in a relational database table with predefined columns (e.g., customer ID, name, address) where every row has the same columns and data types would make structured data the correct answer.
Why candidates choose this
Candidates may think JSON is always structured because it has key-value pairs, overlooking that schema flexibility and nested variability define semi-structured data.
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
Structured data
Structured data is information that is organized in a predefined format, typically in rows and columns, making it easy to search, process, and analyze by computers.
Key term
Semi-structured data
Semi-structured data is information that has some organizational tags or markers but does not fit into a strict table format like a spreadsheet row and column.
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.