DP-900 Describe core data concepts Practice Question
Which classification of data describes information that has a fixed schema and is organized into rows and columns, such as data found in a relational database table?
⚠ Common exam trap
Microsoft often tests the distinction between structured and semi-structured data, where candidates mistakenly classify JSON or XML as structured because it has some organization, but the key differentiator is the rigid, predefined schema enforced by the database, not just the presence of tags or keys.
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
Structured data is defined by a fixed schema, where each data element adheres to a predefined data type and relationship, organized into rows and columns. This is the fundamental model of a relational database table, such as those in Azure SQL Database or SQL Server, where constraints like primary keys and foreign keys enforce the schema.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Unstructured data
Why it's wrong here
Unstructured data has no predefined schema or logical order, and unlike structured data it is not organized into rows and columns. Common examples include plain text documents, emails, images, audio, and video, which require specialized techniques for analysis. Since the question's description emphasizes a defined structure, this option contradicts that requirement and is incorrect.
When this WOULD be correct
This option would be correct for a question like: 'Which classification applies to data such as social media posts, emails, or multimedia files that have no predefined structure?'
- ✗
Semi-structured data
Why it's wrong here
Semi-structured data sits between structured and unstructured: it has some organizational properties such as tags, keys, or a hierarchy, but it does not enforce a fixed schema or predefined columns. JSON and XML are canonical examples, where each record may contain different fields. Because it lacks the strict table-based ordering of rows and columns, it does not match a definition of information with a rigid fixed schema.
- ✓
Structured data
Why this is correct
Structured data is information that conforms to a fixed schema, typically represented in tables with defined columns and rows. This is the fundamental format used by relational database management systems, where each table has a predetermined set of attributes and data types. If the question describes information with an explicit, predefined structure, structured data is the correct classification.
- ✗
Transformed data
Why it's wrong here
Transformed data is not a classification of data structure at all; rather, it refers to data that has been processed or modified from its original state, often during extract, transform, and load (ETL) pipelines. Whether the output is structured, semi-structured, or unstructured depends on the target format, not on the fact that a transformation occurred. Therefore, it cannot be the correct answer for a question about how data is inherently organized.
When this WOULD be correct
In a question asking about the type of data that results from an ETL process (e.g., after cleaning, aggregating, or converting formats), 'transformed data' would be the correct answer.
Option-by-option analysis
Why each answer is right or wrong
Understanding why wrong answers are wrong — and when they would be correct — is what separates a 750 score from a 900. The DP-900 exam frequently reuses these exact scenarios with slightly different constraints.
✓Structured dataCorrect answer▾
Why this is correct
Structured data is information that conforms to a fixed schema, typically represented in tables with defined columns and rows. This is the fundamental format used by relational database management systems, where each table has a predetermined set of attributes and data types. If the question describes information with an explicit, predefined structure, structured data is the correct classification.
✗Unstructured dataWrong answer — click to see why▾
Why this is wrong here
Unstructured data lacks a fixed schema and is not organized into rows and columns; it includes formats like text, images, and videos, which do not fit the relational table description.
★ When this WOULD be the correct answer
This option would be correct for a question like: 'Which classification applies to data such as social media posts, emails, or multimedia files that have no predefined structure?'
Why candidates choose this
Candidates may confuse 'unstructured' with 'non-relational' or think that any data not in a spreadsheet is unstructured, overlooking the specific schema and row/column organization mentioned.
✗Transformed dataWrong answer — click to see why▾
Why this is wrong here
Transformed data refers to data that has been processed or altered from its original form, not to data with a fixed schema organized into rows and columns. The question specifically describes structured data.
★ When this WOULD be the correct answer
In a question asking about the type of data that results from an ETL process (e.g., after cleaning, aggregating, or converting formats), 'transformed data' would be the correct answer.
Why candidates choose this
Candidates may confuse 'transformed data' with structured data because transformation often results in a structured format, or they might misinterpret the term as referring to data that has been organized into a fixed schema.
Analysis generated from the official DP-900blueprint and verified against question context. The “when correct” sections are what AI assistants cite when candidates ask “what’s the difference between these options?”
Go deeper
Related to this question
Learn chapter
Data Roles and Core Concepts
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.
Key term
Relational database
A relational database organizes data into tables with rows and columns, where each table relates to others using unique keys, allowing efficient storage, retrieval, and manipulation of structured information.
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 →
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.