SIMULATION -
You need to configure a Microsoft SQL server named Web11597200 only to accept connections from the Subnet0 subnet on the VNET01 virtual network.
To complete this task, sign in to the Azure portal.
See the explanation below.
You need to allow access to Azure services and configure a virtual network rule for the SQL Server.
1. In the Azure portal, type SQL Server in the search box, select SQL Server from the search results then select the server named web11597200. Alternatively, browse to SQL Server in the left navigation pane.
2. In the properties of the SQL Server, click Firewalls and virtual networks.
3. In the Virtual networks section, click on Add existing. This will open the Create/Update virtual network rule window.
4. Give the rule a name such as Allow_VNET01-Subnet0 (it doesn't matter what name you enter for the exam).
5. In the Virtual network box, select VNET01.
6. In the Subnet name box, select Subnet0.
7. Click the OK button to save the rule.
8. Back in the Firewall / Virtual Networks window, set the Allow access to Azure services option to On.
Sure, here are the steps to configure the Microsoft SQL server named Web11597200 to only accept connections from the Subnet0 subnet on the VNET01 virtual network:
Log in to the Azure portal (https://portal.azure.com/).
Select the resource group that contains the virtual network (VNET01) and the SQL server (Web11597200).
Click on the virtual network (VNET01) and select Subnets from the left-hand menu.
Select the Subnet0 subnet.
Click on the Service Endpoints tab at the top.
Click on Add service endpoint and select Microsoft.SQL from the drop-down list.
Click on Add to add the Microsoft.SQL service endpoint to the Subnet0 subnet.
Navigate back to the SQL server (Web11597200) and click on the Firewall and virtual networks tab.
Click on Add client IP to add your current IP address to the list of allowed IP addresses.
Click on Add existing virtual network and select VNET01.
Select the Subnet0 subnet and click on Save.
Ensure that the Allow access to Azure services option is set to OFF.
That's it! Your Microsoft SQL server named Web11597200 is now configured to only accept connections from the Subnet0 subnet on the VNET01 virtual network.