DP-900 Describe core data concepts Practice Question
A company stores customer contact information in a table with columns for CustomerID, Name, Email, and Phone. They also store customer support chat transcripts as plain text files. Which of the following correctly classifies these data types?
⚠ Common exam trap
It's easy for candidates to confuse semi-structured data (like JSON or XML) with unstructured data (like plain text), incorrectly classifying chat transcripts as semi-structured because they contain some implicit structure (e.g., timestamps or user names) when in fact they lack a formal schema or metadata tags.
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
✓
Customer contact information is structured; chat transcripts are unstructured
Customer contact information stored in a table with columns like CustomerID, Name, Email, and Phone is structured data because it has a fixed schema with rows and columns. Chat transcripts stored as plain text files have no predefined schema or organization, making them unstructured data. Therefore, option C correctly classifies the contact info as structured and the chat transcripts as unstructured.
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 are structured data
Why it's wrong here
This option wrongly assumes chat transcripts are structured. Structured data has a fixed schema with clearly defined rows and columns, strict data types, and a relational model—exactly like the customer contact table—but a chat transcript contains variable-length, free-form text with no columns, no data types, and no consistent layout, so it cannot be stored in a relational table without significant preprocessing or splitting. Furthermore, transcripts do not support standard SQL queries over individual attributes because the content is not broken into discrete, well-defined fields, making them definitively unstructured.
When this WOULD be correct
If the question stated that both datasets are stored in relational database tables with defined schemas (e.g., chat transcripts are stored in a table with columns like ChatID, CustomerID, TranscriptText), then both would be structured data.
- ✗
Customer contact information is structured; chat transcripts are semi-structured
Why it's wrong here
This option incorrectly classifies chat transcripts as semi-structured. Semi-structured data possesses some organizational properties, such as key-value pairs, tags, or hierarchical elements (e.g., JSON or XML), that make it partially parsable; a chat transcript is entirely free text with no such markup or delimiter to separate data elements, so it falls under unstructured data. While the customer contact information is indeed structured, the combination fails because the transcript half of the statement does not meet the definition of semi-structured data.
When this WOULD be correct
If the chat transcripts were stored in a format like JSON or XML with tags for each message, sender, and timestamp, they would be semi-structured, and this option would be correct.
- ✓
Customer contact information is structured; chat transcripts are unstructured
Why this is correct
Customer contact information is structured because it resides in a table with a fixed, predefined schema: each column (name, phone, email) has a strict data type and every row must conform to that schema, making it directly queryable via SQL. Chat transcripts, by contrast, are unstructured because the conversation is free-flowing natural language with no fixed format, row/column structure, or guaranteed fields; the text is stored as a whole and cannot be reliably queried by column value without additional processing like text mining or NLP.
- ✗
Both are semi-structured
Why it's wrong here
This option is wrong because a relational table is not semi-structured: semi-structured data uses self-describing elements such as tags, keys, or markers (e.g., JSON, XML) and does not enforce a rigid schema, whereas the customer contact table has a fixed, predefined schema that every row must follow. Chat transcripts are also not semi-structured because they are plain free text lacking any form of structural markers or metadata tags that separate individual data elements. Therefore, saying both are semi-structured conflates a strictly relational structure with a flexible, self-describing format.
When this WOULD be correct
If the chat transcripts were stored in a format like JSON or XML with tags for each message, timestamp, and agent ID, they would be semi-structured. In that case, both the customer contact table (structured) and the chat logs (semi-structured) would be correctly classified as such.
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.
✓Customer contact information is structured; chat transcripts are unstructuredCorrect answer▾
Why this is correct
Customer contact information is structured because it resides in a table with a fixed, predefined schema: each column (name, phone, email) has a strict data type and every row must conform to that schema, making it directly queryable via SQL. Chat transcripts, by contrast, are unstructured because the conversation is free-flowing natural language with no fixed format, row/column structure, or guaranteed fields; the text is stored as a whole and cannot be reliably queried by column value without additional processing like text mining or NLP.
✗Both are structured dataWrong answer — click to see why▾
Why this is wrong here
Customer contact information in a table with defined columns (CustomerID, Name, Email, Phone) is structured data, but chat transcripts as plain text files have no predefined schema or organization, making them unstructured, not structured.
★ When this WOULD be the correct answer
If the question stated that both datasets are stored in relational database tables with defined schemas (e.g., chat transcripts are stored in a table with columns like ChatID, CustomerID, TranscriptText), then both would be structured data.
Why candidates choose this
Candidates may mistakenly think that all data stored in files is structured, or they may not distinguish between structured and unstructured data, assuming that any tabular data implies structure for all data types.
✗Customer contact information is structured; chat transcripts are semi-structuredWrong answer — click to see why▾
Why this is wrong here
Chat transcripts are plain text files without any inherent structure or metadata, making them unstructured data, not semi-structured (which requires tags or markers like JSON or XML).
★ When this WOULD be the correct answer
If the chat transcripts were stored in a format like JSON or XML with tags for each message, sender, and timestamp, they would be semi-structured, and this option would be correct.
Why candidates choose this
Candidates may confuse 'unstructured' with 'semi-structured' because chat transcripts have some implicit structure (e.g., speaker turns), but without explicit schema or tags, they remain unstructured.
✗Both are semi-structuredWrong answer — click to see why▾
Why this is wrong here
Chat transcripts are plain text files without a predefined schema or structure, making them unstructured data, not semi-structured. Semi-structured data (e.g., JSON, XML) has tags or markers to separate elements, which plain text lacks.
★ When this WOULD be the correct answer
If the chat transcripts were stored in a format like JSON or XML with tags for each message, timestamp, and agent ID, they would be semi-structured. In that case, both the customer contact table (structured) and the chat logs (semi-structured) would be correctly classified as such.
Why candidates choose this
Candidates may confuse 'unstructured' with 'semi-structured' because chat transcripts have some inherent organization (e.g., timestamps, speaker labels) but lack a formal schema, leading them to incorrectly label them 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
Table
A table is a structured collection of data organized into rows and columns, used in databases and spreadsheets to store and manage information efficiently.
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.
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.