Microsoft Azure Architect Design (AZ-304) Practice Test

What is the recommended solution to minimize latency for an Azure SQL Database after enabling forced tunneling?

1. Azure SQL Database Managed Instance

2. Virtual network service endpoints

3. Always On availability groups

4. Azure virtual machines that run Microsoft SQL Server

The correct answer is: Virtual network service endpoints

Minimizing latency for an Azure SQL Database, particularly after enabling forced tunneling, can effectively be achieved through the use of virtual network service endpoints. When you enable service endpoints for Azure SQL Database, you extend your virtual network's private address space and identity directly to the Azure service over an optimized route. This can significantly reduce the round trip between your application and the database, thereby minimizing latency. Virtual network service endpoints offer secure direct connections to your Azure SQL Database while avoiding the need to go through the public internet. This is particularly beneficial in scenarios where forced tunneling is used, as it ensures that all traffic is routed through a specified on-premises network. By using service endpoints, your application can connect to the database with lower latency due to the optimized routing within the Azure backbone network. Additionally, service endpoints enhance security by allowing you to restrict access to your SQL Database only from specific virtual networks or subnets. The other options, such as Azure SQL Database Managed Instance, Always On availability groups, and Azure virtual machines that run Microsoft SQL Server, cater to different use cases and may provide benefits regarding availability, scalability, or on-premises SQL Server compatibility, but do not specifically address the latency concern associated with forced tunneling in the same effective manner