An organization is designing a secure architecture for a cloud application. The application database layer runs on an Azure SQL Database. The application logic runs on Azure Virtual Machines (VMs) deployed in a subnet named AppSubnet within an Azure Virtual Network.
The network security requirements are:
1. Prevent all public internet access to the Azure SQL Database.
2. Allow VMs in AppSubnet to connect securely to the Azure SQL Database.
3. Restrict outbound database traffic from AppSubnet to only the required SQL database.
4. Minimize administrative effort for managing changes to IP addresses.
Which two configurations should you recommend in the design?
- Disable public network access on the Azure SQL logical server.Cevap
- Create a private endpoint for the Azure SQL Database in the virtual network.Cevap
- CCreate outbound Network Security Group (NSG) rules on AppSubnet using the specific public IP addresses of the Azure SQL Database instances in the region.
- DConfigure the AppSubnet Network Security Group (NSG) to allow outbound traffic to the AzureSQL service tag and configure the Azure SQL logical server firewall to allow the public IP of the NAT Gateway associated with AppSubnet.
Cevap
The correct configurations are to disable public network access on the Azure SQL logical server and to create a private endpoint for the Azure SQL Database in the virtual network.
Disabling public network access on the Azure SQL logical server satisfies the absolute restriction of public internet exposure. Creating a private endpoint projects the database onto a private IP address inside the virtual network. This allows the VMs in the subnet to access the database securely and lets administrators write precise NSG outbound rules targeting only that private IP.
Adım Adım Çözüm
Anahtar Kavram
Azure Private Link and Private Endpoints enable secure private access to PaaS services from within a virtual network, allowing public endpoints to be disabled and providing deterministic private IPs for granular security rules.