Microsoft Azure Architect Design (AZ-304) Practice Test

What Azure service enables automated backup services for SQL Server instances migrated to Azure?

1. Azure SQL Database

2. Azure SQL Managed Instance

3. SQL Server on Azure VM

4. Azure Files

The correct answer is: Azure SQL Managed Instance

Azure SQL Managed Instance is the service that provides automated backup features for SQL Server instances that have been migrated to Azure. This service is specifically designed to offer capabilities that closely resemble those available in an on-premises SQL Server environment, including built-in high availability and automated backups. The automated backups in Azure SQL Managed Instance are configured to operate seamlessly, allowing for point-in-time restore capabilities and retention options, which simplify the backup management process compared to managing backups manually on other environments. Azure SQL Database, while also a managed service, is designed for SQL database workloads and has different characteristics compared to a Managed Instance. It does provide backups, but they are less aligned with traditional SQL Server workloads, particularly for larger, more complex databases with certain compatibility requirements. SQL Server on Azure VM allows you to run SQL Server in a virtual machine environment, and while it does offer backup capabilities through Azure Backup or SQL Server built-in features, it does not automate them natively like the Managed Instance does. This means you would need to manage backups manually or through custom scripts, which is less efficient than the automated features of Managed Instance. Azure Files is a service that provides fully managed file shares in the cloud and is not related to SQL Server or its backup capabilities. It serves a