You need to create a new firewall rule to provide the u…

Your company has two offices. The offices are located in London and New York.
The London office has a public IP of 131.107.1.1 and a private IP subnet of 192.168.4.0/24. The New York
office has a public IP of 131.107.15.1 and a private IP subnet of 192.168.8.0/24.
You have a Microsoft SQL Server database that is hosted on a Microsoft Azure virtual machine. Currently, only
the users in the London office use the database.
You need to create a new firewall rule to provide the users in the New York office with access to the database.
The solution must protect the database from being accessed by users on the public Internet.
What should you do?

A.
Modify the endpoint from the Azure portal.

B.
Use the sp_set_database_firewall_rule stored procedure.

C.
Disable the Windows Firewall on the Azure virtual machine.

D.
Run the New-AzureSqlDatabaseServerFirewallRuleAzure PowerShell cmdlet.

E.
Use the Set Firewall Rule REST API.

Explanation:
This Microsoft SQL Server database is hosted on a Microsoft Azure virtual machine. Therefore, remote access
will be provided via the endpoint rather than a database level firewall rule.