Match each Azure data service to its primary purpose.
Drag a concept onto its matching description — or click a concept then click the description.
Relational database as a service
NoSQL multi-model database
Big data and analytics
Unstructured object storage
Scalable data lake for analytics
Answer choices
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
Azure SQL Database: Relational database as a service for structured data.
Azure SQL Database is for relational data, Azure Cosmos DB is a NoSQL globally distributed database, Azure Blob Storage stores unstructured objects, and Azure Synapse Analytics handles big data analytics and warehousing.
Answer analysis
For each option: why learners choose it and why it is or isn't the right answer here.
Azure SQL Database: Relational database as a service for structured data.
Why this is correct
Azure SQL Database is a fully managed relational database service built on the stable SQL Server engine, offering T-SQL, ACID transactions, and a fixed schema to enforce referential integrity. It provides automated backups, patching, and built-in intelligent performance tuning, making it ideal for line-of-business applications and transactional workloads that rely on structured, normalized data.
Azure Cosmos DB: NoSQL database with global distribution and multi-model support.
Why this is correct
Azure Cosmos DB is a globally distributed, multi-model NoSQL database that natively supports document, key-value, graph, and column-family APIs, all backed by a single-write or multi-write-region architecture. It delivers single-digit-millisecond latency with five well-defined consistency levels and elastic horizontal throughput and storage scaling, which suits applications needing continuous global data access.
Azure Blob Storage: Object storage for unstructured data like images and videos.
Why this is correct
Azure Blob Storage is a massively scalable object storage service for unstructured data such as images, videos, log files, and backups, each stored as a blob inside containers. It offers tiered storage from hot to archive to optimize cost and is often used as a data lake foundation, though it does not natively provide query capabilities or database functions. Its strength is durability, capacity, and HTTP(S) access for arbitrary binary or text.
Azure Synapse Analytics: Big data analytics and data warehousing.
Why this is correct
Azure Synapse Analytics is an end-to-end analytics platform that unifies a SQL data warehouse with a Spark-based big data engine and data pipelines, using a massively parallel processing architecture to query petabyte-scale data. It supports both relational and lake-centric scenarios from a single workspace, enabling data warehousing, real-time analytics, and BI reporting, but it is not intended for transaction-heavy OLTP systems.
Azure SQL Database: NoSQL database with global distribution.
Why it's wrong here
This answer is incorrect because Azure SQL Database is fundamentally a relational engine that enforces schema and ACID guarantees, not a NoSQL database, and its distribution is a high-availability and failover capability rather than a global multi-write distribution model. Azure Cosmos DB is the service that matches 'NoSQL database with global distribution and multi-model support,' so the statement swaps the identity of the two services. The primary purpose of SQL Database remains structured relational data management.
Azure Cosmos DB: Object storage for unstructured data.
Why it's wrong here
This answer is incorrect because Azure Cosmos DB is designed as a multi-model NoSQL database that stores data as JSON documents, key-value pairs, graphs, or columnar structures, and it does not act as an object store for raw binary files. Object storage for unstructured data such as images and videos is the precise function of Azure Blob Storage, which offers containers, tiers, and massive-scale HTTP access. Cosmos DB would be a poor fit for storing large media blobs because its focus is on low-latency queries and indexable data.
Quick reference
| 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
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
Big data
Big data refers to extremely large and complex datasets that traditional data processing tools cannot handle efficiently, requiring specialized technologies to store, process, and analyze them.
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 →
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.