Structured Data Classification in Azure
A retail company stores product inventory data in a fixed-schema table with columns for ProductID, ProductName, QuantityInStock, and ReorderLevel. How should this data be classified?
Quick Answer
The correct classification is structured data because the inventory table uses a fixed schema with predefined columns like ProductID, ProductName, QuantityInStock, and ReorderLevel, each enforcing specific data types and relationships. This rigid organization makes the data highly predictable, easily queryable via SQL, and ideal for relational database storage—hallmarks of structured data. On the Microsoft Azure Data Fundamentals DP-900 exam, this concept tests your ability to distinguish structured, semi-structured, and unstructured data, often using real-world scenarios like inventory or customer records. A common trap is confusing structured data with semi-structured formats like JSON or XML, which allow flexible schemas. Remember the mnemonic “Fixed Fields, Fast Filters” to recall that structured data relies on fixed columns and supports efficient filtering and aggregation.
⚠ Common exam trap
It's easy for candidates to confuse structured data with semi-structured data because both involve some organization, but the key distinction is that structured data requires a rigid, predefined schema (like a fixed-schema table), while semi-structured data allows schema flexibility (e.g., JSON with optional fields).
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 data
This data is classified as structured data because it conforms to a fixed schema with clearly defined columns (ProductID, ProductName, QuantityInStock, ReorderLevel) and data types, stored in a relational table. Structured data is highly organized, easily queryable via SQL, and follows a rigid schema, which matches the description of the inventory table.
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 this is correct
Fixed-schema tables with defined columns and typed values are structured data, typically stored in relational databases. The explicit ProductID, ProductName, QuantityInStock and ReorderLevel columns fit the relational model, so structured classification applies rather than semi-structured or unstructured.
- ✗
Semi-structured data
Why it's wrong here
The table has a fixed schema with defined columns and data types, which is structured data; semi-structured data relies on flexible schemas such as JSON or XML with tags. It is tempting because semi-structured formats are common in modern applications, but a rigid relational-style table does not fit that classification.
- ✗
Unstructured data
Why it's wrong here
Fixed columns with defined types constitute structured data; unstructured data has no predefined schema, such as images, video or free text. It is tempting because inventory records may include descriptions, but the presence of named, typed columns means the data is structured, not unstructured.
- ✗
Streaming data
Why it's wrong here
Streaming data describes how data is ingested continuously in real time, not its schema shape; the question asks how the stored inventory table is classified. It is tempting because retail inventory can arrive via event streams, but the fixed-schema table itself is structured data regardless of ingestion method.
Go deeper
Related to this question
Learn chapter
Star Schema vs Snowflake Schema
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
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
Courseiva writes every DP-900 question from scratch — 851 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
1 more way 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 receives data from a point-of-sale system. Each row contains TransactionID, ProductID, Quantity, and Price. The data has a fixed schema and is stored in a table. How should this data be classified?
easy- ✓ A.Structured data
- B.Semi-structured data
- C.Unstructured data
- D.Transactional data
Why A: The data has a fixed schema with clearly defined columns (TransactionID, ProductID, Quantity, Price) and each row follows the same structure, which is the definition of structured data. In Azure, this would map directly to a table in Azure SQL Database or a fixed-schema table in Azure Synapse Analytics. The rigid schema and consistent data types make it ideal for relational storage and querying.
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.