Zephyr Logistics is designing a secure hybrid networking architecture. The environment consists of an on-premises datacenter with local Active Directory DNS servers, an Azure subscription with a hub virtual network and a peered spoke virtual network, and an ExpressRoute connection linking the on-premises datacenter to the hub virtual network. Virtual machines (VMs) are deployed in a subnet named AppSubnet in the spoke virtual network to host a business-critical application that connects to an Azure SQL Database containing sensitive customer records.
The architecture must meet the following requirements:
- The Azure SQL Database must not be exposed to the public internet.
- The VMs in AppSubnet must connect to the database securely using the private IP address of the database.
- On-premises client machines must be able to resolve and query the database using the same fully qualified domain name (FQDN) as the Azure VMs.
- Administrative overhead for security rules and DNS management must be minimized.
Which two actions should you recommend to meet these requirements?
- Configure a Private Endpoint for the Azure SQL Database in the spoke virtual network, and link the Azure Private DNS zone named privatelink.database.windows.net to the hub virtual network.Cevap
- Configure an inbound endpoint on the Azure Private DNS Resolver in the hub virtual network, and configure the on-premises DNS servers to forward queries for database.windows.net to the private IP address of the inbound endpoint.Cevap
- CConfigure a Network Security Group (NSG) on the spoke subnet with outbound security rules that target the individual public IP addresses of the Azure SQL Database gateway endpoints.
- DCreate a route table with a User Defined Route (UDR) in the spoke subnet that routes all traffic destined for the SQL Database Private Endpoint IP address to the on-premises VPN gateway, overriding the default system routes.
- EDeploy a Standard Load Balancer in the spoke virtual network to distribute traffic to the SQL Database Private Endpoint, and associate virtual machines using Basic SKU public IP addresses to the load balancer backend pool.