Your company has an on-premises datacenter connected to an Azure Virtual Network (VNet) via a site-to-site VPN. You are designing a secure private access solution for a business-critical application running on virtual machines in the VNet. The application needs to connect to an Azure SQL Database. You must meet the following requirements:
- The Azure SQL Database must not accept connections from the public internet.
- The virtual machines must access the database using private IP addresses.
- On-premises database administrators must be able to manage the database using private IP addresses.
- On-premises DNS servers must resolve the database FQDN to its private IP address.
- Administrative overhead for security rule maintenance and DNS routing must be minimized.
Which network security design should you recommend?
- Deploy a Private Endpoint for the Azure SQL Database. Configure an Azure DNS Private Resolver in the VNet, and set up conditional forwarding on the on-premises DNS servers to route database FQDN queries to the resolver's inbound endpoint. Apply a Network Security Group (NSG) utilizing the SQL Service Tag to secure database traffic.Cevap
- BDeploy a Private Endpoint for the Azure SQL Database. Configure a DNS forwarder VM in Azure to resolve the database FQDN. Apply a Network Security Group (NSG) on the virtual machine subnet containing manual outbound rules for each individual public IP address block of the regional Azure SQL Database gateway endpoints.
- CDeploy a Service Endpoint for the Azure SQL Database. Configure a User-Defined Route (UDR) on the virtual machine subnet that routes all database traffic to a virtual appliance, and configure a second overlapping route for the destination to override system-defined routes for the database connection.
- DDeploy a Private Endpoint for the Azure SQL Database. Place a Basic Load Balancer in the VNet to distribute traffic to the private endpoint. Associate a Standard SKU Public IP address with the load balancer to allow secure remote administration from the on-premises environment.