Question
When to choose Cosmos DB vs Azure SQL?
Click to reveal answer
Answer
Cosmos DB for global distribution, variable schemas, guaranteed low latency. Azure SQL for relational data, complex joins, ACID transactions, and SQL Server compatibility.
Click to flip back
All Data & Infrastructure Flashcards
Q: When to choose Cosmos DB vs Azure SQL?
A: Cosmos DB for global distribution, variable schemas, guaranteed low latency. Azure SQL for relational data, complex joins, ACID transactions, and SQL Server compatibility.
Q: How do you calculate composite SLA?
A: Multiply individual SLAs: e.g., App Service (99.95%) × SQL DB (99.99%) = 99.94%. Add redundancy to increase SLA above single-service levels.
Q: When to use hub-spoke vs Virtual WAN?
A: Hub-spoke for smaller deployments with custom routing control. Virtual WAN for large-scale with many branches, automated routing, and Microsoft-managed infrastructure.
Q: What is RPO vs RTO?
A: RPO (Recovery Point Objective): max acceptable data loss measured in time. RTO (Recovery Time Objective): max acceptable downtime before services are restored.
Q: When should you use Azure Front Door?
A: For global HTTP/HTTPS load balancing with SSL offloading, WAF, URL-based routing, and session affinity across multiple regions.