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
You are designing a data storage solution for a social media application that stores user profile pictures and uploaded photos. The solution must support high throughput and be optimized for reading and writing large binary objects. Which Azure data service should you recommend?
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 optimized for storing large amounts of unstructured data, such as images and videos, and provides high throughput for read/write operations, making it ideal for user profile pictures and uploaded photos. Azure Files (A) is a managed file share for SMB/NFS, not optimized for high-throughput binary object operations. Azure SQL Database (C) is a relational database for structured data, not designed for large binary objects. Azure Cosmos DB (D) is a NoSQL database primarily for structured or semi-structured data, not for storing large blobs efficiently.
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 Files
Why it's wrong here
Azure Files provides fully managed SMB and NFS file shares for scenarios like shared configuration files, on-premises extension, or lifting and shifting existing file-based applications. However, it is not optimized for high-throughput binary object storage like images because it is constrained by file-share semantics, lower per-file size limits, and throughput that cannot match the scale of Azure Blob Storage. For hosting a social media platform's image files, the blob storage service is the appropriate choice due to its ability to serve millions of concurrent HTTP requests.
- ✓
Azure Blob Storage
Why this is correct
Azure Blob Storage is a fully managed, massively scalable object store that is the correct choice for storing and serving large numbers of image files, such as those posted on a social media platform. It provides extremely high throughput, supports storage tiers for optimizing cost, and can serve blobs directly via HTTP/HTTPS, enabling straightforward use with CDNs for low-latency access worldwide. Blobs can be accessed using REST APIs and SDKs, making it ideal for unstructured binary data.
- ✗
Azure SQL Database
Why it's wrong here
Azure SQL Database is a relational database optimized for transactional workloads with structured tabular data and a defined schema. It can store binary files as BLOBs, but doing so quickly leads to inflated database sizes, slower query performance, and higher costs due to reliance on transactional log backups and indexed access. It is fundamentally unsuited for high-volume, write-heavy image storage; in practice, you would store the images in Blob Storage and keep only metadata or the blob URL in SQL.
- ✗
Azure Cosmos DB
Why it's wrong here
Azure Cosmos DB is a globally distributed, multi-model NoSQL database designed for low-latency access to structured and semi-structured JSON documents. While it supports attachments, the size limit for documents and the overhead of storing binary payloads as base64 make it an inefficient choice for large image files. Cosmos DB is meant for queries on records, not for bulk object storage, and its pricing is based on request units that would spike if you streamed gigabytes of image data.
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
Azure SQL Database
Azure SQL Database is a fully managed relational database-as-a-service (DBaaS) in Microsoft Azure, based on the SQL Server engine, that handles scaling, backups, patching, and high availability automatically.
Key term
Azure Cosmos DB
Azure Cosmos DB is a fully managed, globally distributed NoSQL database service that offers fast reads and writes anywhere in the world with automatic scaling and multiple consistency models.
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.