Relational data
CoreAzure SQL Database
Managed relational database service for cloud applications.
Key points
- Azure SQL Database provides managed relational databases without a customer-managed SQL Server instance or guest OS.
- Compute model, isolation, scaling, backup, recovery, and compatibility must match each database workload.
Best-known use cases
- Host cloud relational databases that favor platform management over instance-level control.
What candidates often confuse it with
- SQL Database minimizes instance administration; Managed Instance offers broader instance compatibility and SQL Server on VMs preserves guest control.
Key takeaway
Choose Azure SQL Database for isolated cloud databases whose requirements fit the managed database boundary.
Relevant exam tasks
- D2.1.S1 — Recommend a solution for storing relational data
- D2.1.S2 — Recommend a database service tier and compute tier
- D2.1.S3 — Recommend a solution for database scalability
- D2.1.S4 — Recommend a solution for data protection
- D3.1.S3 — Recommend a backup and recovery solution for databases
- D3.2.S2 — Recommend a high availability solution for relational data