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-AzureSqlDatabaseServerFirewallRule Azure 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 prov

ided via the endpoint rather than a database level firewall rule.