You have a report that runs against a Microsoft Azure SQL database.
The report takes more time to return results than expected.
You add an index to a table in the database.
You need to identify whether adding the index improves the performance issue. What should you use?

You have Microsoft SQL Server installed on a Microsoft Azure virtual machine. The virtual machine is on the
Standard D3 service tier. All of the data files for the databases on the virtual machine are located on a single
volume that is mounted as drive E.
The virtual machine experiences performance issues.
You view the wait statistics and discover a high number of РАGEIOLATCH_SH waits associated to the tempdb
data files.
You need to resolve the performance issues.
What should you do?

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 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:

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:

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.

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?

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 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.

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: