You have an on-premises line-of-business (LOB) application that uses a Microsoft SQL Server instance as the backend. You plan to migrate the on-premises SQL Ser...
Microsoft AZ-305 Exam
Questions Number: 180 out of 268 Questions
67.16%
Question 180
You have an on-premises line-of-business (LOB) application that uses a Microsoft SQL Server instance as the backend. You plan to migrate the on-premises SQL Server instance to Azure virtual machines. You need to recommend a highly available SQL Server deployment that meets the following requirements: - Minimizes costs Minimizes failover time if a single server fails What should you include in the recommendation?
Always On availability groups on Azure Virtual Machines are similar to Always On availability groups on-premises, and rely on the underlying Windows Server Failover Cluster. If you deploy your SQL Server VMs to a single subnet, you can configure a virtual network name (VNN) and an Azure Load Balancer, or a distributed network name (DNN) to route traffic to your availability group listener. There are some behavior differences between the functionality of the VNN listener and DNN listener that are important to note: * Failover time: Failover time is faster when using a DNN listener since there is no need to wait for the network load balancer to detect the failure event and change its routing. * Etc. Incorrect: Not B, not D: Migrate to an Always On availability group, not an Always on Failover cluster Instance. Reference: https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/availability-group-overview
