Practice Questions
Question 1
Which statement best describes unstructured data?
A. Data organized in rows and columns
B. Data with flexible key–value pairs
C. Data without a predefined schema or consistent structure
D. Data stored only in relational databases
✅ Answer: C
Explanation:
Unstructured data has no predefined schema and does not naturally fit into tables.
Question 2
Which of the following is an example of unstructured data?
A. A customer table in Azure SQL Database
B. A JSON document
C. A PDF document
D. A CSV file
✅ Answer: C
Explanation:
PDF documents are classic unstructured data. JSON is semi-structured, and CSV is structured.
Question 3
Which Azure service is primarily used to store unstructured data such as images and videos?
A. Azure SQL Database
B. Azure Cosmos DB
C. Azure Blob Storage
D. Azure Table Storage
✅ Answer: C
Explanation:
Azure Blob Storage is Azure’s primary service for storing unstructured data like media files and documents.
Question 4
Why can’t unstructured data typically be queried directly using SQL?
A. SQL is deprecated
B. Unstructured data lacks a schema
C. SQL only works on cloud platforms
D. Unstructured data is encrypted
✅ Answer: B
Explanation:
SQL relies on schemas and tables. Unstructured data has no inherent structure, so it requires additional processing before analysis.
Question 5
Which workload most commonly generates unstructured data?
A. Financial transaction systems
B. Inventory databases
C. Media content platforms
D. Payroll systems
✅ Answer: C
Explanation:
Media platforms generate images, videos, and audio — all unstructured data.
Question 6
How is unstructured data typically stored?
A. As relational records
B. As nested documents
C. As files or binary objects
D. As key–value pairs
✅ Answer: C
Explanation:
Unstructured data is stored as files or blobs, not rows or documents.
Question 7
Which capability is commonly required to extract meaning from unstructured text data?
A. SQL joins
B. Index clustering
C. Natural language processing
D. Primary keys
✅ Answer: C
Explanation:
Unstructured text requires NLP or AI techniques to derive insights.
Question 8
Which statement correctly compares unstructured and semi-structured data?
A. Both require fixed schemas
B. Semi-structured data has no internal organization
C. Unstructured data contains embedded keys
D. Semi-structured data is machine readable, unstructured typically is not
✅ Answer: D
Explanation:
Semi-structured data (like JSON) contains keys/tags, while unstructured data does not.
Question 9
A company stores call recordings and scanned documents for compliance. What type of data is this?
A. Structured
B. Semi-structured
C. Unstructured
D. Relational
✅ Answer: C
Explanation:
Audio files and scanned documents are unstructured data.
Question 10
Which is a key characteristic of unstructured data?
A. Strong data typing
B. Fixed schema
C. Hierarchical documents
D. Requires AI or analytics tools for interpretation
✅ Answer: D
Explanation:
Unstructured data typically needs AI, machine learning, or analytics tools (such as computer vision or text analytics) to extract meaning.
✅ Quick Exam Takeaways
For DP-900, remember:
- Unstructured data has no schema
- Stored as files/blobs
- Not directly queryable with SQL
- Requires AI or analytics for insight
- Common Azure service: Azure Blob Storage
- Examples: images, videos, PDFs, audio, free-form text
Go to the DP-900 Exam Prep Hub main page.
The Data Community 