Microsoft
70-473 · Question #2
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.
The correct answer is B. EXECUTE sp_set_database_firewall_rule N'NewYork, '192.168.8.0', `192.168.8.255';. https://msdn.microsoft.com/en-gb/library/dn270010.aspx
Design and implement data security
Question
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?
Options
- AEXECUTE sp_set_database_firewall_rule N'NewYork,'131.107.15.1','255.255.255.255'
- BEXECUTE sp_set_database_firewall_rule N'NewYork, '192.168.8.0', `192.168.8.255';
- CEXECUTE sp_set_database_firewall_rule N'NewYork,'192.168.8.0', '255.255.255.0';
- DEXECUTE sp_set_database_firewall_rule N'NewYork,'131.107.15.1','131.107.15.1';
How the community answered
(27 responses)- A4% (1)
- B74% (20)
- C15% (4)
- D7% (2)
Explanation
Topics
#Azure SQL Database firewall#Network security#sp_set_database_firewall_rule
Community Discussion
No community discussion yet for this question.