DP-900 Practice Question: Identify considerations for relational data on Azure
A company is designing a new application that will store customer orders in a relational database on Azure. The data includes order IDs, customer IDs, product IDs, quantities, and order dates. The application needs to support complex queries that join multiple tables and enforce referential integrity. Which Azure service should the company use?
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 SQL Database
Azure SQL Database is the correct choice because it is a fully managed relational database service that supports complex queries with JOINs and enforces referential integrity. In contrast, Azure Cosmos DB is a NoSQL database, Azure Table Storage is a key-value store, and Azure Blob Storage is for unstructured data, none of which are suitable for relational requirements.
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 this is correct
Azure SQL Database is a fully managed relational database engine that provides complete T-SQL support, including table joins with various join types, primary/foreign key enforcement, check constraints, and ACID transactions. This makes it the only option in the list that natively supports the referential integrity and complex relational queries expected when designing an application that stores customer data across normalized tables. It also offers built-in high availability, automated backups, and scaling options, so it aligns with both the relational data model and operational requirements.
- ✗
Azure Table Storage
Why it's wrong here
Azure Table Storage is a NoSQL key-value and wide-column store that organizes data into entities accessed by a partition key and a row key. It does not support server-side joins, foreign keys, or any relational integrity constraints, so modeling customers with related child records would require manual client-side lookups, repeated queries, and denormalized entity designs. While it is highly scalable for simple lookups, it is not a relational database and cannot serve the need for complex relational queries described in the scenario.
- ✗
Azure Cosmos DB
Why it's wrong here
Azure Cosmos DB is a globally distributed, multi-model NoSQL database service that supports document, graph, key-value, and column-family APIs. Although it can perform limited intra-document self-joins and client-side composable queries, it does not enforce foreign keys or cross-partition referential integrity, and complex relational joins are typically avoided in favor of denormalized data models. Its design priorities are horizontal scale, low latency, and flexible schemas—features that trade away the relational guarantees this application requires.
- ✗
Azure Blob Storage
Why it's wrong here
Azure Blob Storage is an object storage service designed for unstructured data, such as images, videos, backups, or text files, stored in flat containers with metadata and a URL-based address. It has no query engine capable of performing relational joins, enforcing constraints, or executing predicate-based SQL across objects; retrieving related customer data would require downloading and processing objects in application code. Therefore, it is completely inappropriate for hosting a relational schema for a customer-centric application.
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
Blob storage
Blob storage is a cloud service for storing large amounts of unstructured data, such as text or binary data, like documents, images, and videos.
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.