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
Correct - The data has a fixed schema organized in rows and columns, which is the definition of structured data.
- ✗
Semi-structured data
Why it's wrong here
Incorrect - Semi-structured data, like JSON or XML, has some organizational properties but does not require a rigid schema. The inventory data has a fixed schema.
- ✗
Unstructured data
Why it's wrong here
Incorrect - Unstructured data refers to data that has no predefined data model, such as video files or emails. The inventory data is clearly organized.
- ✗
Streaming data
Why it's wrong here
Incorrect - Streaming data refers to data that is continuously generated from sources like IoT devices, not the classification of the data at rest.
Go deeper
Related to this question
Learn chapter
Data Roles and Core Concepts
Key term
Data
Data is raw, unprocessed information, like numbers, words, or measurements, that can be stored, processed, and analyzed by computers.
Key term
Table
A table is a structured collection of data organized into rows and columns, used in databases and spreadsheets to store and manage information efficiently.
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 →
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.