Microsoft Azure Architect Design (legacy) — Question 26

You use Azure virtual machines to run a custom application that uses an Azure SQL Database instance on the back end.
The IT department at your company recently enabled forced tunneling.
Since the configuration change, developers have noticed degraded performance when they access the database.
You need to recommend a solution to minimize latency when accessing the database. The solution must minimize costs.
What should you include in the recommendation?

Answer options

• A. Azure SQL Database Managed Instance
• B. virtual network service endpoints
• C. Always On availability groups
• D. Azure virtual machines that run Microsoft SQL Server servers

Correct answer: B

Explanation

The correct answer is B, virtual network service endpoints, as they provide a direct connection to the Azure SQL Database, reducing latency and improving performance without incurring significant costs. The other options, such as A and C, may provide high availability or additional features but do not specifically address latency issues or may involve higher costs. Option D is not relevant as it refers to running SQL Server on virtual machines rather than optimizing access to Azure SQL Database.