You have an Azure SQL server named Server1 that hosts two development databases named DB1 and DB2.
You have an administrative workstation that has an IP address of 192.168.8.8. The development team at your company has an IP addresses in the range of
192.168.8.1 to 192.168.8.5.
You need to set up firewall rules to meet the following requirements:
-> Allows connection from your workstation to both databases.
-> The development team must be able connect to DB1 but must be prevented from connecting to DB2.
-> Web services running in Azure must be able to connect to DB1 but must be prevented from connecting to DB2.
Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Click on the arrows to vote for the correct answer
A. B. C. D. E.ACE
To set up firewall rules to meet the requirements, you need to create firewall rules on the Azure SQL server, Server1, to allow connections from specified IP addresses.
The actions to be performed are as follows:
A. Create a firewall rule on DB1 that has a start IP address of 192.168.8.1 and an end IP address of 192.168.8.5. This rule allows connections from IP addresses in the range of 192.168.8.1 to 192.168.8.5 to connect to DB1, which is required by the development team.
B. Create a firewall rule on DB1 that has a start and end IP address of 0.0.0.0. This rule allows connections from any IP address to connect to DB1, which is not required in this scenario, and hence this option is incorrect.
C. Create a firewall rule on Server1 that has a start IP address of 192.168.8.1 and an end IP address of 192.168.8.5. This rule allows connections from IP addresses in the range of 192.168.8.1 to 192.168.8.5 to connect to both DB1 and DB2, which is not required in this scenario, as the development team should only be allowed to connect to DB1.
D. Create a firewall rule on DB1 that has a start and end IP address of 192.168.8.8. This rule allows connections only from the administrative workstation with IP address 192.168.8.8 to connect to DB1, which is required by the administrator.
E. Create a firewall rule on Server1 that has a start and end IP address of 192.168.8.8. This rule allows connections only from the administrative workstation with IP address 192.168.8.8 to connect to both DB1 and DB2, which is required by the administrator.
Therefore, the correct actions to be performed are A, D, and E.