You have a Microsoft Azure SQL database. The database is hosted in the West US region and uses the
Premium service tier. Users of the database are located in Los Angeles, New York, and Singapore.
The users in Singapore report that when they run reports against the database, the reports take a long time to
complete. The reports contain thousands of rows.
You need to recommend a solution to resolve the performance issue. The solution must maintain the
performance for the other users. What should you include in the recommendation?

DRAG DROP
You have four Microsoft Azure SQL databases located on the same database server.
You need to configure the databases to be in an elastic database pool.
Which four 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.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders
you select.
Select and Place:

You plan to implement a Microsoft Azure SQL database.
You need to create and manage the new database on a new server.
Which three cmdlets should you use? Each correct answer presents part of the solution.

You have a Microsoft Azure SQL database that is used for reporting.
You discover that some reports complete more quickly than other reports, even though the reports retrieve
approximately the same amount of data and use queries that have the same table structure.
You need to reduce the amount of time it takes to complete the reports.
What should you use?

A customer plans to monitor the performance of a Microsoft Azure SQL database.
You need to explain to the customer which metrics are used to calculate the Database Throughput Unit (DTU)
percentage. Which three metrics should you identify? Each correct answer presents part of the solution.

You have an application that uses a Microsoft SQL Server database on a Microsoft Azure virtual machine.
The application experiences performance issues, which you suspect are related to the connection pooling. The
issues are prevalent only when there are more than 150 concurrent connections.
You need to identify whether the performance issues are related to the connection pooling.
Which dynamic management view should you query?

DRAG DROP
You have several instances of Microsoft SQL Server on several Microsoft Azure virtual machines.
You need to implement an automated process to back up all of the virtual machines to an Azure storage
account. The process must run weekly.
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 Microsoft SQL Server 2014 installed on a Microsoft Azure virtual machine.
One of the databases on the virtual machine supports a highly active Online Transaction Processing (OLTP)
application. Users report abnormally long wait times when they submit data in the application.
Which two tools can you use to identify the longest running queries? Each correct answer presents a complete
solution.

You have several SQL Server instances on Microsoft Azure virtual machines.
Periodically, one of the virtual machines runs more slowly than expected. The issue typically persists for up to
30 minutes. You investigate the issue and discover that when the issue occurs, there is high CPU usage on the
virtual machines.
You need to be notified automatically when the performance issue occurs. You want to achieve this goal by
using the minimum amount of administrative effort.
What should you configure?

You have Microsoft SQL Server installed on a Microsoft Azure virtual machine named VM1. VM1 is provisioned
by using the classic deployment model and is on the Standard GS5 service tier.
The virtual machine is used for testing purposes only.
You need to minimize the costs associated with VM1 when the virtual machine is unused.
Which command should you use?