Well, when reviewing database services for your exam, it’s important to understand which Azure solution fits which scenario.
Start with the Azure SQL Database this is your go-to for building cloud-native apps that need a fully managed or intelligent database that can scale easily.
Then keep in mind, your Azure SQL managed instances that you have, which are ideal when you’re modernizing existing server apps, but still want to manage the environment with minimal changes.
Design for Azure SQL Managed Instance
If you need full control over the operating system and the SQL server, especially for legacy workloads, study the SQL server on Azure virtual machines. You will need to understand that. This option gives you the most flexibility and is the closest to the traditional on-prem setup. So, keep those things in mind. You’ll need to know the differences in the use cases.
Design for SQL Server on Azure Virtual Machines
For open-source databases, there are a few options, like your Azure Database for PostgreSQL which is great for high-performance. You have the Azure Database for MySQL which is another one that’s a managed service that supports mobile and web apps. And finally, the Azure Database for MariaDB, which offers similar benefits for teams, and people already using MariaDB in their stats.
*** MISSING ***
Understand these various databases, understand their use cases, and practice deploying them in preparation for your exam.
| If you want to | Use this database service |
| Build apps that scale with a managed and intelligent SQL database in the cloud. | Azure SQL Database |
| Modernize SQL Server applications with a managed, always-up-to-date SQL instance in the cloud. | Azure SQL Managed Instance |
| Migrate your SQL workloads to Azure while maintaining complete SQL Server compatibility and operating system-level access. | SQL Server on Azure Virtual Machines |
| Build scalable, secure, and fully managed enterprise-ready apps on open-source PostgreSQL, scale out single-node PostgreSQL with high performance, or migrate PostgreSQL and Oracle workloads to the cloud. | Azure Database for PostgreSQL |
| Deliver high availability and elastic scaling to open-source mobile and web apps with a managed community MySQL database service or migrate MySQL workloads to the cloud. | Azure Database for MySQL |
| Deliver high availability and elastic scaling to open-source mobile and web apps with a managed community MariaDB database service. | Azure Database for MariaDB |