DP-900 Describe core data concepts Practice Question
A social media platform stores user posts as JSON documents. Each document contains text content, image URLs, timestamps, and user tags. The structure is consistent for most fields, but users can add custom key-value pairs. How should this data be classified?
⚠ Common exam trap
Microsoft often tests the misconception that any data with a consistent field is structured, but the presence of optional custom key-value pairs makes it semi-structured, not 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
✓
Semi-structured data
The data is semi-structured because it has a consistent schema for most fields (text, image URLs, timestamps, user tags) but allows custom key-value pairs, which introduces schema flexibility. JSON documents inherently support this mix of fixed and variable attributes, fitting the semi-structured data classification. This aligns with Azure Cosmos DB's handling of JSON items, where each document can have a different set of properties.
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 data
Why it's wrong here
Structured data is defined by a rigid, predefined schema where every record must conform to the same fixed columns and data types, typically enforced by a relational database management system (RDBMS). JSON documents with optional custom fields violate this requirement because each document can have a different set of keys, and fields may be nested or omitted entirely. Thus, while JSON has syntactic structure, it does not satisfy the fixed-schema constraint that characterizes structured data.
- ✓
Semi-structured data
Why this is correct
Semi-structured data exhibits organizational properties—such as key-value pairs, tags, and hierarchical nesting—but does not require a uniform, predefined schema across all instances. JSON documents fit this category perfectly because they use explicit keys to define their internal structure, yet the presence and type of those keys can vary from one document to another. This schema-flexibility, combined with inherent self-description, distinguishes semi-structured data from both rigid structured data and completely structureless unstructured data.
- ✗
Unstructured data
Why it's wrong here
Unstructured data has no inherent machine-readable structure, meaning there are no defined keys, field names, or hierarchical relationships that software can directly interpret; examples include raw text, images, audio, and video. JSON, in contrast, has a well-defined syntax (objects, arrays, key-value pairs) and is self-describing, so even though its schema can vary, it always possesses an explicit structural framework that software can parse. Therefore, JSON does not qualify as unstructured data because its metadata and organization are embedded within the document itself.
- ✗
Relational data
Why it's wrong here
Relational data is organized into tables with rows and columns, enforces a strict schema via constraints, and establishes relations through primary and foreign keys to maintain integrity and enable joins. JSON documents are typically stored as standalone entities in NoSQL document databases (e.g., Azure Cosmos DB, MongoDB) and are not normalized into separate tables; they do not inherently enforce referential integrity or relational algebra operations. Thus, despite the possible presence of identifiers that appear similar to keys, JSON as a storage format is not relational because it lacks the schema and join semantics required by the relational model.
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
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
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 →
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.