An enterprise is designing a hybrid network architecture to connect an on-premises datacenter to an Azure virtual network named `VNet1` using an ExpressRoute connection. A subnet in `VNet1` named `Subnet1` hosts virtual machines that must access an Azure SQL Database.
The design must meet the following requirements:
- The Azure SQL Database must not expose a public endpoint and must be accessible only via a private IP address within `VNet1`.
- On-premises applications must be able to resolve the database's fully qualified domain name (FQDN) to its private IP address.
- Outbound traffic from `Subnet1` to the database must be restricted at the network layer using Network Security Groups (NSGs).
- Administrative effort for managing DNS routing and network security rules must be minimized.
Which design should you recommend?
- AConfigure a Service Endpoint for Microsoft.Sql on Subnet1. Associate an NSG with Subnet1 and configure outbound security rules containing the individual public IP addresses of the Azure SQL Database regional endpoints. Configure the on-premises DNS servers to forward queries for database.windows.net to the Azure default DNS IP address ().
- Deploy a Private Endpoint for the Azure SQL Database in a dedicated subnet. Enable private endpoint network policies on the subnet. Configure an Azure DNS Private Resolver with an inbound endpoint in VNet1, and link a private DNS zone named privatelink.database.windows.net to VNet1. Configure the on-premises DNS servers to forward queries for database.windows.net to the inbound endpoint IP.Cevap
- CDeploy a Private Endpoint for the Azure SQL Database in Subnet1. Link a private DNS zone named privatelink.database.windows.net to VNet1. Create a User-Defined Route (UDR) on Subnet1 that routes all traffic destined for the database FQDN to the ExpressRoute Virtual Network Gateway, overriding the default system routes.
- DDeploy a Private Endpoint for the Azure SQL Database in a dedicated subnet. Link a private DNS zone named privatelink.database.windows.net to VNet1. Manually configure the on-premises DNS servers with static A records pointing to the database's private IP address, and configure an NSG on Subnet1 with outbound rules targeting the individual public IP addresses of the database.