Relational Data
- Azure SQL Database for PaaS with auto-tuning and built-in HA.
- SQL Managed Instance for 100% SQL Server compatibility (lift-and-shift).
- Elastic pools share resources across databases with variable usage patterns.
- Active geo-replication for read replicas and DR across regions.
Non-Relational Data
- Cosmos DB for globally distributed, multi-model, low-latency data.
- Storage accounts: blob (objects), files (SMB), queues (messages), tables (NoSQL).
- Data Lake Storage Gen2 for big data analytics with hierarchical namespace.
- Choose consistency level based on CAP theorem trade-offs.
Practice Data Storage Questions
Put your knowledge to the test with practice questions.