DP-900 Describe core data concepts Practice Question
A consulting firm collects client information in two forms: a spreadsheet with columns for Name, Address, and Phone Number, and audio recordings of client meetings. Which of the following statements correctly categorizes these data types?
⚠ Common exam trap
Watch out — candidates often confuse semi-structured data (e.g., JSON, XML with tags) with unstructured data (e.g., audio, video, images), leading candidates to incorrectly classify audio recordings as semi-structured because they contain metadata, but the content itself is 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
✓
The spreadsheet data is structured, and the audio recordings are unstructured.
The spreadsheet data with columns for Name, Address, and Phone Number has a predefined schema (rows and columns), making it structured data. Audio recordings are binary files with no inherent schema or organization, fitting the definition of unstructured data. Option C correctly pairs these classifications.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Both the spreadsheet data and the audio recordings are examples of structured data.
Why it's wrong here
This option is incorrect because audio recordings do not share the defining property of structured data. Structured data requires a rigid, predefined schema where every record has the same attributes (e.g., columns in a database table), and the data can be directly queried with relational operations. Audio recordings are just a sequence of sampled amplitude values over time, carrying meaning only through complex interpretation; they have no columns, no data types like text or numbers in a tabular sense, and no straightforward way to run SQL-like queries. Therefore, the audio portion cannot be classified as structured, making this statement false.
When this WOULD be correct
If the question described the spreadsheet as having a fixed schema (e.g., Name, Address, Phone) and the audio recordings as having metadata tags (e.g., speaker, date, topic) that impose some structure, then both could be considered structured or semi-structured. For example: 'A spreadsheet with columns Name, Address, Phone, and audio files with metadata tags for speaker and date.'
- ✗
The spreadsheet data is structured, and the audio recordings are semi-structured.
Why it's wrong here
This option misclassifies audio recordings as semi-structured. Semi-structured data sits between structured and unstructured: it has some organizational markers, such as tags, keys, or hierarchical elements (examples include JSON, XML, and Parquet), which allow limited parsing and querying. Audio recordings lack any such markers—a WAV, MP3, or AAC file contains only encoded signal data plus minimal metadata like sample rate or duration, but no internal field structure that describes the content's meaning. Because the actual spoken or acoustic content carries no parseable schema, audio cannot be considered semi-structured; it is unstructured, regardless of the spreadsheet being correctly identified as structured.
When this WOULD be correct
If the question described the spreadsheet as having a flexible schema (e.g., some rows missing columns) and the audio recordings as having metadata tags (e.g., speaker labels, timestamps), then the spreadsheet could be semi-structured and the audio semi-structured, but that scenario is not given here.
- ✓
The spreadsheet data is structured, and the audio recordings are unstructured.
Why this is correct
A spreadsheet is structured because it has a fixed schema: a defined set of columns, each with a consistent data type and rows that conform to that schema, allowing direct querying via SQL or similar tools. In contrast, audio recordings exist as continuous analog or digital signal streams with no inherent fields, keys, or column definitions. They cannot be directly indexed, searched, or queried without first applying preprocessing such as speech-to-text or audio feature extraction, which is the defining characteristic of unstructured data.
- ✗
The spreadsheet data is semi-structured, and the audio recordings are unstructured.
Why it's wrong here
This option incorrectly labels the spreadsheet as semi-structured. A spreadsheet typically consists of rows and columns with a defined schema: column headers indicate fields (e.g., client name, date, balance), and each row is a record conforming to those fields, with data types per column. That is exactly the definition of structured data, not semi-structured, which would require self-describing, flexible schemas like JSON arrays or XML documents where fields can vary per record. While some spreadsheet applications allow mixed or loosely typed cells, the canonical interpretation for data classification in DP-900 is that a spreadsheet is structured. Since it is not semi-structured, the statement is false, even though the audio classification as unstructured is correct.
When this WOULD be correct
If the spreadsheet contained free-form text in a single column (e.g., a 'Notes' column with paragraphs) and the audio recordings were tagged with metadata (e.g., timestamps, speaker labels), then the spreadsheet would be semi-structured and the audio recordings unstructured.
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.
✓The spreadsheet data is structured, and the audio recordings are unstructured.Correct answer▾
Why this is correct
A spreadsheet is structured because it has a fixed schema: a defined set of columns, each with a consistent data type and rows that conform to that schema, allowing direct querying via SQL or similar tools. In contrast, audio recordings exist as continuous analog or digital signal streams with no inherent fields, keys, or column definitions. They cannot be directly indexed, searched, or queried without first applying preprocessing such as speech-to-text or audio feature extraction, which is the defining characteristic of unstructured data.
✗Both the spreadsheet data and the audio recordings are examples of structured data.Wrong answer — click to see why▾
Why this is wrong here
Audio recordings are unstructured data (free-form, no predefined schema), not structured. Structured data has a rigid schema like rows and columns, which applies only to the spreadsheet.
★ When this WOULD be the correct answer
If the question described the spreadsheet as having a fixed schema (e.g., Name, Address, Phone) and the audio recordings as having metadata tags (e.g., speaker, date, topic) that impose some structure, then both could be considered structured or semi-structured. For example: 'A spreadsheet with columns Name, Address, Phone, and audio files with metadata tags for speaker and date.'
Why candidates choose this
Candidates may think that any data stored in a file (like audio) is structured, or they confuse 'structured' with 'organized' rather than the technical definition of having a predefined schema.
✗The spreadsheet data is structured, and the audio recordings are semi-structured.Wrong answer — click to see why▾
Why this is wrong here
Audio recordings lack a predefined data model or schema, making them unstructured, not semi-structured. Semi-structured data (e.g., JSON, XML) has tags or markers to separate data elements, which audio does not.
★ When this WOULD be the correct answer
If the question described the spreadsheet as having a flexible schema (e.g., some rows missing columns) and the audio recordings as having metadata tags (e.g., speaker labels, timestamps), then the spreadsheet could be semi-structured and the audio semi-structured, but that scenario is not given here.
Why candidates choose this
Candidates may confuse 'semi-structured' with 'unstructured' because both lack rigid schemas, or they might think audio files with metadata (like ID3 tags) qualify as semi-structured, overlooking that the raw audio content itself is unstructured.
✗The spreadsheet data is semi-structured, and the audio recordings are unstructured.Wrong answer — click to see why▾
Why this is wrong here
The spreadsheet data is structured because it has a fixed schema (columns: Name, Address, Phone Number), not semi-structured. Semi-structured data has tags or markers but no rigid schema, like JSON or XML.
★ When this WOULD be the correct answer
If the spreadsheet contained free-form text in a single column (e.g., a 'Notes' column with paragraphs) and the audio recordings were tagged with metadata (e.g., timestamps, speaker labels), then the spreadsheet would be semi-structured and the audio recordings unstructured.
Why candidates choose this
Candidates may confuse 'semi-structured' with any data that is not fully normalized or contains some variability, mistakenly thinking a simple spreadsheet without a strict relational schema qualifies as semi-structured.
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
Structured data
Structured data is information that is organized in a predefined format, typically in rows and columns, making it easy to search, process, and analyze by computers.
Key term
Unstructured data
Unstructured data is information that does not have a predefined data model or is not organized in a predefined manner, making it difficult for traditional databases to read and process.
About these practice questions
One of 820 original DP-900 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.