DP-900Domain 2: Identify Considerations for Relational Data on AzureRelational Data on AzuremediumSingle choice
An app stores orders with strict referential integrity, complex multi-table JOINs, and T-SQL reporting requirements. Which Azure service fits?
A.Azure Cosmos DB
Cosmos is document NoSQL — no rich cross-entity joins.
B.Azure SQL Database
Relational + T-SQL = SQL Database. Correct.
C.Azure Blob Storage
Blob is object storage — not a queryable database.
D.Azure Table Storage
Table Storage is simple key-attribute — no joins.
Why this answer
Multi-table JOINs + referential integrity + T-SQL = relational engine requirements → Azure SQL Database. Cosmos DB handles JSON documents at global scale but joins are intra-partition/limited; Blob/Table aren't queryable relational stores.
Correct answer: B · Last reviewed 2026-11-05
Official AWS references
Practice this interactively
Answer without seeing the solution first in the Relational Data on Azure practice session.
Practice Relational Data on Azure