You have a Microsoft Azure virtual machine named SQL1 that has Microsoft SQL Server 2016 installed. SQL1 has a critical database that contains online transaction data. The database is 700 GB. You regularly perform full database backups. On a separate…

Your environment contains several Microsoft Azure SQL databases. You need to execute Transact-SQL-based maintenance steps automatically against the databases. The execution must occur weekly. What should you use? A. a SQL Server Agent job B. an Azure Schedule job C.…

You have a Microsoft Azure SQL database. You need to provide a copy of the database to an auditor. What should you do? A. Run the CREATE DATABASE statement and use the AS COPY OF clause. B. Run the CREATE…

Your environment contains several Microsoft Azure SQL databases. You need to prevent inbound connections from the Internet to the databases when CPU utilization exceeds 90 percent. Which two tasks should you perform? Each correct answer presents part of the solution.…

You have a Microsoft Azure SQL database. Users report that queries to the database take longer than expected to complete. You need to identify the amount of CPU resources that the database used during the last week. What should you…

Your company identifies a stored procedure that runs slowly. You review the execution plan for the stored procedure, and you discover the properties of a Clustered Index Scan operator as shown in the exhibit. (Click the Exhibit button.) The stored…

You have a Microsoft Azure virtual machine that has Microsoft SQL Server installed. The virtual machine contains five databases. You need to identify whether the performance of queries to the databases has degraded during the last two weeks. Which SQL…

You have a Microsoft SQL Server instance that is hosted on a Microsoft Azure virtual machine. You need to identify the most recent wait type for all of the currently running queries in the instance. What should you use? A.…

Your Microsoft Azure environment contains an elastic pool that has 2,000 eDTUs. The current available storage for the pool is 500 GB. At 10:00 each morning, the databases in the pool are slow to respond to queries. You need to…

Your company has an application that uses several Microsoft Azure SQL databases. New databases are added regularly as customers sign up for new services. Databases are removed regularly as customers cancel the services. You create an auditing policy. You plan…