Microsoft 70-473 Exam Actual Questions

DRAG DROP -
You have a Microsoft Azure virtual machine that hosts a Microsoft SQL Server database.
You need to configure firewall rules to meet the following requirements:
✑ Access the database remotely.
✑ Manage the server remotely by using Windows PowerShell.
✑ Manage the server remotely by using Remote Desktop.
Which Azure endpoint ports should you open? To answer, drag the appropriate ports to the correct types of access. Each port may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Select and Place:

Correct Answer:

You have a Microsoft SQL Server instance on a Microsoft Azure virtual machine.
The members of an Active Directory group named HelpDesk can log in to the SQL Server instance.
You need to ensure that the members of HelpDesk can query dynamic management views and gather performance metrics from the SQL Server instance.
Which three actions should you perform? Each correct answer presents part of the solution.

Correct Answer: BDF 🗳️
References:
https://msdn.microsoft.com/en-us/library/ms188754.aspx

You have a Microsoft Azure SQL database.
You need to ensure that you can use the Always Encrypted feature for the database.
Which two components should you configure? Each correct answer presents part of the solution.

Correct Answer: A 🗳️
References:
https://azure.microsoft.com/en-gb/documentation/articles/sql-database-always-encrypted/

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?

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