Describe considerations for working with non-relational data on Azure →mediumMultiple ChoiceObjective-mapped
DP-900 Practice Question: Describe considerations for working with non-relational data on Azure
A media company needs to store millions of high-resolution photos for a public website. Each photo can be up to 50 MB. The storage solution must support secure access via URLs. Which Azure service should they use?
⚠ Common exam trap
Test-takers frequently confuse Azure Files with Blob Storage because both can store files, but Azure Files uses SMB protocol for network file shares, not HTTP/HTTPS URL-based access for public web serving.
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 is the correct choice because it is designed for storing massive amounts of unstructured data, such as high-resolution photos, and supports objects up to 4.7 TB per blob, easily accommodating 50 MB files. It provides secure access via URLs using shared access signatures (SAS) or public access levels, making it ideal for a public website serving media content.
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 Table Storage
Why it's wrong here
Azure Table Storage is a NoSQL key-value store designed for structured entities with up to 1 MB per entity, making it ill-suited for high-resolution images that are large binary files. Its query model relies on partition and row keys for fast lookups, not for serving object data with direct URL access. Consequently, storing millions of photos would require fragmenting them or storing only metadata/pointers, defeating the purpose and adding complexity.
- ✓
Azure Blob Storage
Why this is correct
Azure Blob Storage is Microsoft's object storage solution optimized for massive volumes of unstructured binary data, perfect for high-resolution photos. Each block blob can hold up to 4.75 TB and you can store millions of blobs, each directly addressable via a unique HTTPS URL—making it trivial to serve images to browsers or mobile apps and integrate with Azure CDN for global scalability. It also offers tiered storage (hot, cool, archive) to balance cost and access frequency, which is essential for media companies.
- ✗
Azure Files
Why it's wrong here
Azure Files provides fully managed SMB and NFS file shares for traditional file-based applications, typically used as shared storage for VMs or on-premises users. It is not architected to serve millions of high-res photos over the internet; it lacks object-level URL access and its throughput/concurrency limits are far lower than Blob Storage when dealing with massive parallel reads. Mounting hundreds of thousands of clients to a file share is impractical, whereas Blob Storage's REST API is designed for global, high-scale content distribution.
- ✗
Azure SQL Database
Why it's wrong here
Azure SQL Database is a relational database management system for transactional data requiring ACID guarantees, not a storage service for large binary files. Storing millions of high-resolution images as BLOB columns would bloat the database, degrade query and backup performance, and drastically increase cost compared to offloading objects to Blob Storage. The rational design is to store photo metadata/URLs in SQL and the actual binary content in Blob Storage, not the reverse.
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
Data Roles and Core Concepts
Key term
Data
Data is raw, unprocessed information, like numbers, words, or measurements, that can be stored, processed, and analyzed by computers.
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.
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.