A company is planning to migrate a legacy on-premises electronic health record (EHR) application to Azure. The relational database for the application has the following requirements:
- Must support SQL Server Agent to run nightly maintenance jobs.
- Must support Database Mail to send automated notifications to administrators.
- Must be deployed into a private, delegated subnet within an Azure Virtual Network.
- In the event of a regional disaster, all database backups must remain available.
- The administrative overhead for managing operating system patching and hardware updates must be minimized.
Which Azure SQL deployment option should you recommend?
- AAzure SQL Database single database configured with Private Link and zone-redundant storage (ZRS) backups.
- Azure SQL Managed Instance configured with geo-redundant storage (GRS) backups.Cevap
- CAzure SQL Managed Instance configured with locally redundant storage (LRS) backups.
- DSQL Server on Azure Virtual Machines using Standard HDD storage for database log files.
Cevap
Azure SQL Managed Instance configured with geo-redundant storage (GRS) backups
The option recommending Azure SQL Managed Instance with geo-redundant storage (GRS) backups is correct because it meets all requirements. Azure SQL Managed Instance is a fully managed PaaS service that supports instance-level features such as SQL Server Agent and Database Mail. It runs inside a delegated subnet within a virtual network. Using GRS backups ensures that backups survive a regional disaster while avoiding the administrative overhead of OS patching associated with virtual machines.
Adım Adım Çözüm
Anahtar Kavram
Azure SQL service comparison based on legacy feature support, network requirements, and management overhead