DP-900 Describe core data concepts Practice Question
A company collects customer feedback in three forms: a structured table with customer ID and rating (1-5), free-text comments, and audio recordings of phone calls. Which of the following correctly orders these data from least structured to most structured?
⚠ Common exam trap
Candidates may mistakenly classify free-text comments as semi-structured, but in DP-900, free-text is considered unstructured. The trap is to recognize that both audio and free-text are unstructured, so the correct ordering places them before structured 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
✓
Audio recordings, free-text comments, structured table
Ly orders the data from least structured to most structured. Audio recordings are unstructured (no schema). Free-text comments are also unstructured (no fixed format in DP-900 classification). The structured table has defined columns and data types. Thus, the order is audio (unstructured), free-text (unstructured), structured table.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Audio recordings, free-text comments, structured table
Why this is correct
Correct. Audio and free-text are both unstructured; the structured table is most structured.
- ✗
Structured table, free-text comments, audio recordings
Why it's wrong here
Incorrect. This orders structured first, which is most structured, not least.
When this WOULD be correct
If the question asked to order data from most structured to least structured, then this option (structured table, free-text comments, audio recordings) would be correct.
- ✗
Free-text comments, structured table, audio recordings
Why it's wrong here
Incorrect. This places free-text (unstructured) before structured table, but then places audio after structured, mixing order.
When this WOULD be correct
If the question asked to order data from most structured to least structured, then option C (free-text comments, structured table, audio recordings) would be correct, as it places structured table second and audio last.
- ✗
Audio recordings, structured table, free-text comments
Why it's wrong here
Incorrect. This places audio (unstructured) first, then structured table, then free-text (unstructured) last, which is not from least to most structured.
When this WOULD be correct
If the question asked to order from most structured to least structured, then D (Audio recordings, structured table, free-text comments) would be correct because it starts with the most structured (table) and ends with the least structured (audio).
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.
✓Audio recordings, free-text comments, structured tableCorrect answer▾
Why this is correct
Correct. Audio and free-text are both unstructured; the structured table is most structured.
✗Structured table, free-text comments, audio recordingsWrong answer — click to see why▾
Why this is wrong here
This option orders data from least structured to most structured incorrectly. Structured data (table) is the most structured, not the least; audio recordings are unstructured, and free-text comments are semi-structured.
★ When this WOULD be the correct answer
If the question asked to order data from most structured to least structured, then this option (structured table, free-text comments, audio recordings) would be correct.
Why candidates choose this
Candidates may mistakenly think that structured data is 'simple' and thus least structured, or they confuse the direction of ordering (least to most vs. most to least).
✗Free-text comments, structured table, audio recordingsWrong answer — click to see why▾
Why this is wrong here
This option incorrectly orders free-text comments as less structured than a structured table. Free-text comments are semi-structured (unorganized text), while structured tables are fully structured with defined schema. Audio recordings are unstructured, so the correct order is audio, free-text, structured table.
★ When this WOULD be the correct answer
If the question asked to order data from most structured to least structured, then option C (free-text comments, structured table, audio recordings) would be correct, as it places structured table second and audio last.
Why candidates choose this
Candidates may mistakenly think free-text comments are more structured than a table because they are text-based, or they may confuse 'structured' with 'organized content' rather than schema-defined data.
✗Audio recordings, structured table, free-text commentsWrong answer — click to see why▾
Why this is wrong here
This option incorrectly places the structured table before free-text comments, but structured data (table) is the most structured, not intermediate. Audio recordings are least structured, free-text comments are semi-structured, and structured table is most structured.
★ When this WOULD be the correct answer
If the question asked to order from most structured to least structured, then D (Audio recordings, structured table, free-text comments) would be correct because it starts with the most structured (table) and ends with the least structured (audio).
Why candidates choose this
Candidates may mistakenly think that free-text comments are more structured than audio because they are text, but they lack a predefined schema, making them semi-structured, while audio is unstructured.
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
Azure AI Search for Unstructured Data
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
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 851-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.