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