DP-900 Describe core data concepts Practice Question
A company stores customer data in a SQL table with fixed columns (CustomerID, Name, Email, SignupDate). They also store product images as JPEG files and application logs as JSON documents. Which of the following correctly classifies each data type?
⚠ Common exam trap
A common mix-up: candidates confuse semi-structured data (like JSON) with unstructured data (like images), or assuming that any file format with a standard (like JPEG) is semi-structured, when in fact JPEG is purely binary and unstructured.
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
✓
SQL table: structured, JPEG: unstructured, JSON: semi-structured
A SQL table with fixed columns enforces a rigid schema, making it structured data. JPEG files are binary blobs with no internal schema, classifying them as unstructured. JSON documents use key-value pairs with flexible schemas, which is the definition of semi-structured data.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
SQL table: structured, JPEG: unstructured, JSON: semi-structured
Why this is correct
SQL tables enforce a rigid schema via predefined columns and data types, so every row must conform to that fixed structure, which is the definition of structured data. A JPEG file is a binary image format that stores encoded pixel data and metadata; it has no row/column organization or queryable schema, making it unstructured. JSON documents use key-value pairs and can have optional or nested fields, so they are self-describing and flexible, which is classic semi-structured data. Thus, all three classifications here are accurate.
- ✗
SQL table: structured, JPEG: semi-structured, JSON: unstructured
Why it's wrong here
This option correctly labels SQL as structured, but it misclassifies JPEG as semi-structured. A JPEG file contains compressed image data with headers and encoding parameters, but those are not a data schema—there are no queryable fields or relationships, so it is unstructured, not semi-structured. It also mislabels JSON as unstructured, but JSON inherently defines structure through its key-value pairs and nesting; it simply lacks a fixed schema, which is exactly why it belongs in the semi-structured category. So the two non-SQL classifications are reversed.
- ✗
SQL table: semi-structured, JPEG: unstructured, JSON: structured
Why it's wrong here
Calling SQL semi-structured is incorrect because an SQL table's fixed columns and enforced data types give it a strict schema that is defined before data is inserted; that is the essence of structured data. At the other extreme, JSON is not structured because it does not require a predefined schema—documents can vary in their fields and nesting, which is the definition of semi-structured. Only the JPEG classification as unstructured is correct, but with the other two swapped, the overall answer fails. The critical distinction is whether the schema is fixed and enforced (structured) or flexible and self-describing (semi-structured).
- ✗
SQL table: unstructured, JPEG: structured, JSON: semi-structured
Why it's wrong here
This option errs by labeling SQL as unstructured, but an SQL table's columns, data types, and constraints constitute a fixed, enforced schema, making it structured. It also designates JPEG as structured, but a JPEG file is a binary container for compressed image data without tabular or schema-based organization, so it is unstructured. JSON's semi-structured classification is the only correct piece here, yet the other two misclassifications invalidate the answer. Having an internal format like a JPEG header does not equate to structured data in the data-architecture sense, which relies on a queryable schema.
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 →
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.