Microsoft
70-473 · Question #7
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 publ
The correct answer is A. Modify the endpoint from the Azure portal.. This Microsoft SQL Server database is hosted on a Microsoft Azure virtual machine. Therefore, remote access will be provided via the endpoint rather than a database level firewall
Design and implement data security
Question
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?
Options
- AModify the endpoint from the Azure portal.
- BUse the sp_set_database_firewall_rule stored procedure.
- CDisable the Windows Firewall on the Azure virtual machine.
- DRun the New-AzureSqlDatabaseServerFirewallRule Azure PowerShell cmdlet.
- EUse the Set Firewall Rule REST API.
How the community answered
(34 responses)- A79% (27)
- B3% (1)
- C3% (1)
- D12% (4)
- E3% (1)
Explanation
This Microsoft SQL Server database is hosted on a Microsoft Azure virtual machine. Therefore, remote access will be provided via the endpoint rather than a database level firewall
Topics
#SQL Server on Azure VM#Network security#Firewall rules#Azure Portal endpoints
Community Discussion
No community discussion yet for this question.