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?

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’;

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



Leave a Reply 4

Your email address will not be published. Required fields are marked *


Jamesk

Jamesk

answer should be D.

spguru

spguru

I think the answer is correct.

Jamesk

Jamesk

on closer look ‘ private IP subnet of 192.168.8.0/24’ would imply a range of:
192.168.8.0 start and 255.255.255.0 end as the subnet mask /24 stipulates.
therfore my answer is C.

sunil

sunil

2^32-24 = 2^8 = 256

0 -255 is right answer