Which command should you execute?

Your company has two offices 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 Azure SQL database. Currently, only the users in the London office use the

database. You plan to provide the users in the New York office with access to the database. You need to ensure that the New York office users can access the database.

Which command should you execute?
A . EXECUTE sp_set_database_firewall_rule N’NewYork,’131.107.15.1’,’255.255.255.255’
B . EXECUTE sp_set_database_firewall_rule N’NewYork, ’192.168.8.0’, ‘192.168.8.255’;
C . EXECUTE sp_set_database_firewall_rule N’NewYork,’192.168.8.0’, ’255.255.255.0’;
D . EXECUTE sp_set_database_firewall_rule N’NewYork,’131.107.15.1’,’131.107.15.1’;

View Answer

Answer: B

Explanation:

References: http://azure.patrickkeisler.com/2015/11/configuring-the-azure-sql-database-firewall/ https://msdn.microsoft.com/en-gb/library/dn270010.aspx