Microsoft Azure

Azure SQL and Cosmos DB

Compare Azure SQL and Azure Cosmos DB through data model, access patterns, consistency, scaling, managed operations, and recovery.

Intermediate14 min read
Microsoft Azure lessonCloud foundationsPractice

UNTIMED COACHING

Practice before the pressure

Use feedback to correct the model, not merely memorize an option position.

GUIDED PRACTICE

Practice the lesson questions

Answer normal lesson questions without a timer. Every answer includes an explanation, and incorrect answers can be tried again before continuing.

CONCEPT MODELS

See the lesson as a system

Use these visual guides to connect the key ideas before answering the questions.

Map the roles in Azure SQL and Cosmos DBConnect azure sql data, cosmos db items, managed database, and consistency and scale as distinct cloud roles.
Map the roles in Azure SQL and Cosmos DBA cloud model connects four subject-specific roles used in azure sql and cosmos db without collapsing their boundaries.
Data tableAzure SQL data
Data recordCosmos DB items
Managed serviceManaged database
Scaling decisionConsistency and scale
Verify Database recoveryConnect database recovery with its starting inspection, expected result, and explicit safety boundary.
Verify Database recoveryA cloud verification model connects database recovery with an inspection, result, and safety boundary.
Backup boundaryDatabase recovery
Starting checkInspect database recovery first
Expected resultVerify database recovery outcome
Safety boundaryProtect database recovery state