Structured vs Unstructured Data: Understanding Data Types for DP-900
A company processes sales transactions in real-time from a retail website. Each transaction is recorded as a row in a relational database. Additionally, the company stores weekly sales reports as PDF files. Which statement correctly describes these data types?
Quick Answer
The correct answer is that transactions are structured data and reports are unstructured data. This distinction hinges on the presence of a predefined schema: the sales transactions are recorded as rows in a relational database, which imposes a fixed structure of columns and data types, making them easily queryable with SQL. In contrast, the weekly sales reports stored as PDF files lack any such schema or data model, requiring additional processing like OCR or text extraction to be queried. On the Microsoft Azure Data Fundamentals DP-900 exam, this question tests your ability to classify data types based on storage format rather than content—a common trap is assuming all business documents are semi-structured. Remember the memory tip: if it fits neatly into rows and columns, it’s structured; if it’s a free-form file like a PDF or image, it’s unstructured.
⚠ Common exam trap
It's easy for candidates to confuse 'file format' with 'data structure', assuming all files are structured, when in fact PDFs are unstructured binary files that lack the row/column schema of relational data.
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
✓
Transactions are structured, reports are unstructured.
Transactions are structured because they are stored as rows in a relational database, which imposes a fixed schema with defined columns and data types. Weekly sales reports as PDF files are unstructured because they lack a predefined data model and cannot be easily queried using SQL without additional processing. Option B correctly identifies this distinction.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Transactions are unstructured, reports are semi-structured.
Why it's wrong here
Incorrect. Transactions have a fixed schema so they are structured, not unstructured. Reports are not semi-structured; they lack a schema.
- ✓
Transactions are structured, reports are unstructured.
Why this is correct
Correct. Transactions have a rigid schema (structured), and PDF files lack a predefined schema (unstructured).
- ✗
Both are structured because they are files.
Why it's wrong here
Incorrect. Only data with a fixed schema is structured. PDF files do not have a predictable schema.
- ✗
Both are unstructured because they are digital.
Why it's wrong here
Incorrect. Digital data can be structured (e.g., database tables) or unstructured (e.g., PDFs).
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
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 — 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
2 more ways 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 stores product information such as product ID, name, price, and category in a relational database with rows and columns. This data is best described as:
easy- ✓ A.Structured data
- B.Semi-structured data
- C.Unstructured data
- D.Transactional data
Why A: Structured data conforms to a predefined schema with rows and columns, making it easily searchable and queryable via SQL. The product information (ID, name, price, category) fits this model exactly, as each attribute has a fixed data type and is stored in a relational database table.
Variation 2. A data file contains records for customer orders. Each record has fields for OrderID, CustomerID, and OrderDate that are present in every record. However, some records include an optional 'DiscountCode' field, and others include an optional 'GiftMessage' field. The file is stored in JSON format. Which type of data does this file represent?
easy- A.Structured data
- ✓ B.Semi-structured data
- C.Unstructured data
- D.Transactional data
Why B: The JSON file contains records with a fixed set of fields (OrderID, CustomerID, OrderDate) that are always present, but also includes optional fields (DiscountCode, GiftMessage) that may appear in some records but not others. This mix of a consistent schema with flexible, self-describing fields is the hallmark of semi-structured data. JSON itself is a semi-structured format because it uses key-value pairs and allows nested or optional attributes without requiring a rigid schema.
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.