You have an on-premises Microsoft SQL Server 2014 database in an AlwaysOn availability group. You are planning a backup solution for the database. Backups will run on a secondary replica. You need to create a backup procedure for the database.…

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 A. New-AzureSqlDatabaseServer B. New…

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…

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…

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

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…