Match each data type to its category in Azure.
Drag a concept onto its matching description — or click a concept then click the description.
Relational tables with fixed schema
JSON, XML, or key-value pairs
Blobs, files, and media
Data in tables with relationships
NoSQL data like documents or graphs
Answer choices
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
Relational data: Stored in tables with predefined schema and relationships (Structured)
Understanding data types helps choose the right Azure service. Structured data fits Azure SQL Database, semi-structured fits Cosmos DB, unstructured fits Blob Storage.
Answer analysis
For each option: why learners choose it and why it is or isn't the right answer here.
Relational data: Stored in tables with predefined schema and relationships (Structured)
Why this is correct
Relational data is inherently structured because it must conform to a fixed schema defined by tables, columns, data types, and constraints. Relationships are enforced through primary and foreign keys, enabling consistent joins and ACID transactions. This rigid, predictable organization is what distinguishes structured data from semi-structured or unstructured formats in Azure, where services like Azure SQL Database or Azure Database for PostgreSQL are designed to store it.
JSON data: Stored as key-value pairs with flexible schema (Semi-structured)
Why this is correct
JSON data is classified as semi-structured because it does not require a fixed schema; each object can contain a different set of key-value pairs, and values can be nested or of varying types. This flexibility allows JSON documents to evolve over time without schema migrations, making it ideal for NoSQL stores like Azure Cosmos DB. Although JSON has a lightweight text-based syntax, it lacks the rigid table-and-relationship structure that defines relational data, placing it between structured and unstructured categories.
Video files: Binary data without internal structure (Unstructured)
Why this is correct
Video files are unstructured because they store binary data as a continuous stream of bytes (e.g., encoded frames in MP4 or AVI) with no predefined schema that database systems can query directly. Unlike structured tables or semi-structured JSON, video files carry no inherent field names, relationships, or metadata that can be parsed for relational operations. In Azure, such data is typically stored in Blob Storage or Azure Data Lake Storage, and any searchable metadata must be maintained separately as sidecar data.
Relational data: Stored as key-value pairs with flexible schema (Semi-structured)
Why it's wrong here
This pairing is incorrect because relational data does not consist of flexible key-value pairs; it relies on a fixed, predefined schema of tables, columns, and relationships. Key-value stores like Azure Table Storage or Cosmos DB Table API are designed for semi-structured or schema-less data, permitting rows with different attributes. Relational systems enforce structural consistency and referential integrity, which is fundamentally incompatible with the schema-free nature of key-value pairs.
JSON data: Stored in tables with predefined schema and relationships (Structured)
Why it's wrong here
This pairing is incorrect because JSON's flexible schema and nested key-value structure do not fit within relational tables that require predefined columns and data types. Relational databases enforce schema on write, meaning every row must adhere to the same column set, whereas JSON objects can have varying fields and nested hierarchies. Therefore, placing JSON into a structured relational model would sacrifice exactly the flexibility that makes JSON semi-structured in the first place.
Video files: Stored as key-value pairs (Semi-structured)
Why it's wrong here
This pairing is incorrect because video files are binary blobs, not collections of key-value pairs; they contain encoded pixel and audio data without any intrinsic schema or field-level organization. Semi-structured data like JSON or XML consists of named elements and attributes that can be parsed and queried, whereas video formats offer no such logical structure. Storing video in a key-value store is possible (with the file as a value), but the data itself remains unstructured—the key-value container does not change the nature of the video content.
Go deeper
Learn chapter
Data Roles and Core Concepts
Key term
Azure SQL Database
Azure SQL Database is a fully managed relational database-as-a-service (DBaaS) in Microsoft Azure, based on the SQL Server engine, that handles scaling, backups, patching, and high availability automatically.
Key term
Data
Data is raw, unprocessed information, like numbers, words, or measurements, that can be stored, processed, and analyzed by computers.
About these practice questions
This DP-900 question is part of Courseiva's 820-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
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.