Everything You Need to Pass: microsoft 70_473

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.

You have a Microsoft SQL Server 2014 instance on a Microsoft Azure virtual machine.You need to ensure that all SQL Server audits are written to the Windows Security log.Which two actions should you perform? Each correct answer presents part of the solution.

DRAG DROP -You hire a new employee to assist in the management of a Microsoft Azure SQL database.You need to ensure that the employee can query dynamic management views.Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.Select and Place:

DRAG DROP -You have an AlwaysOn availability group between several Microsoft Azure virtual machines.You need to ensure that the databases meet the following requirements:Database files and backup files must be encrypted always.The encryption strategy must minimize changes to the databases and to applications.The solution must prevent any disruption to replication.Which four actions should you perform in sequence? I answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.Select and Place:

You deploy a Microsoft SQL Server instance on a Microsoft Azure virtual machine by using a template.You plan to deploy a PHP-based app in an Azure web app. The web app will use a database on the virtual machine. The web app and the virtual machine will be on the same Azure virtual network.You need to ensure that the web app can access the SQL Server database.Which three actions should you perform? Each correct answer presents part of the solution.

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: