Microsoft
70-473 · Question #2
70-473 Question #2: Real Exam Question with Answer & Explanation
Sign in or unlock 70-473 to reveal the answer and full explanation for question #2. The question stem and answer options stay visible for context.
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';
Unlock 70-473 to see the answer
You've previewed enough free 70-473 questions. Unlock 70-473 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.