DP-900 Describe core data concepts Practice Question
Which TWO of the following are valid Azure data storage services for storing unstructured data?
⚠ Common exam trap
Many exam-takers confuse semi-structured data (e.g., Table Storage, Cosmos DB) with unstructured data, or incorrectly assume that any NoSQL service qualifies as unstructured storage, when in fact only object storage services like Blob Storage and Data Lake Storage Gen2 are designed for raw, schema-less binary 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
✓
Azure Blob Storage
Azure Blob Storage (C) is correct because it is Microsoft's core object storage service designed specifically for massive amounts of unstructured data such as text, binary, images, video, and backups, accessible via REST/HTTPS and the Blob SDK. Azure Data Lake Storage Gen2 (D) is correct because it is built on Blob Storage with a hierarchical namespace enabled, purpose-built for storing and analyzing unstructured and semi-structured big data (e.g., logs, JSON, Parquet) at scale. Azure SQL Database (A) is a relational PaaS engine that stores structured data in tables with a fixed schema, so it is not intended for unstructured data. Azure Table Storage (B) is a NoSQL key-attribute store for structured, schema-less tabular data, not for unstructured blobs. Azure Cosmos DB (E) is a globally distributed multi-model database for structured/semi-structured JSON documents, key-value, graph, and column-family data, not a general unstructured object store.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Azure SQL Database
Why it's wrong here
Azure SQL Database is a fully managed relational database service in Microsoft's PaaS model, specifically designed for structured, schema-based data. It stores data in tables with rows and columns, enforces relationships and constraints, and is queried using T-SQL. Although it offers data types like VARBINARY for binary content, it is not a general-purpose object or file storage service and therefore does not qualify as an unstructured data storage solution for this question.
- ✗
Azure Table Storage
Why it's wrong here
Azure Table Storage is a NoSQL key-value store that persists structured entities in a table format without requiring a fixed schema. It organizes data by partition key and row key and is optimized for fast, scalable access to structured, semi-structured, or even some JSON-like entity data. Because it is designed for structured NoSQL entities rather than unstructured files, text, or binary data, it is not a correct answer here.
- ✓
Azure Blob Storage
Why this is correct
Azure Blob Storage is Microsoft's highly scalable object storage service for unstructured data, including text, binary files, images, videos, and application backups. It organizes data into containers with flat namespaces and supports tiered storage (hot, cool, cold, archive) to optimize cost and access patterns. This makes it a core building block for storing and serving unstructured content at massive scale, which is why it is a correct answer.
- ✓
Azure Data Lake Storage Gen2
Why this is correct
Azure Data Lake Storage Gen2 is built directly on top of Azure Blob Storage and adds a hierarchical namespace plus POSIX-compatible access control lists, giving it file-system-like semantics. This makes it purpose-built for big data analytics workloads that need to run distributed processing across massive volumes of unstructured and semi-structured data. Its ability to support high-throughput, petabyte-scale analytics distinguishes it from standard object storage for OLTP or simple file serving.
- ✗
Azure Cosmos DB
Why it's wrong here
Azure Cosmos DB is a globally distributed, multi-model NoSQL database service that supports document, key-value, wide-column, and graph data models. It is designed for low-latency access to structured or semi-structured JSON data and provides SLA-backed performance and replication. Because it is fundamentally a transactional database engine, not an object storage service for raw unstructured files, it does not qualify as a correct answer for this question.
Quick reference
Azure Blob Storage Tier Comparison
| Tier | Storage Cost | Retrieval Cost | Latency | Use Case |
|---|---|---|---|---|
| Hot | Highest | Lowest | Immediate | Active data, frequent reads |
| Cool | Lower | Higher | Immediate | Data accessed < once / month |
| Cold | Lower still | Higher | Immediate | Data accessed < once / quarter |
| Archive | Lowest | Highest + rehydration delay | Hours | Long-term compliance retention |
Go deeper
Related to this question
Learn chapter
Cosmos DB Partitioning Strategies
Key term
Service
A service is a software component or system that performs a specific function and is available to be used by other programs or users over a network.
Key term
Data Lake Storage Gen2
Data Lake Storage Gen2 is a cloud-based storage service that combines a scalable data lake with enterprise-grade file system capabilities for big data analytics.
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.