70-765 – Provisioning SQL Databases

DRAG DROP

You are responsible for deploying and maintaining the Microsoft SQL Server virtual machines (VMs) in Microsoft Azure. You use Azure Resource Group templates to deploy and modify the VMs.

With the exception of their names, all deployed VMs must be identical. You may need to add additional data disks to the VMs in the future.

You need to streamline the template creation and deployment process as much as possible.

For each requirement, what should you do? To answer, drag the appropriate actions or features to the correct locations. Each action or feature 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.

Select and Place:

DRAG DROP

You upgrade a database named DB1 to Microsoft SQL Server 2016.

Users report that performance for several queries is degraded. You determine that the query optimizer is incorrectly estimating the number of rows that the queries will return.

You need to resolve the performance issues.

How should you complete the Transact-SQL statement? To answer, drag the Transact-SQL segments to the correct locations. Each Transact-SQL segment 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:

HOTSPOT

You have an on-premises database.

You plan to migrate the database to Microsoft SQL Server on a Microsoft Azure virtual machine.

You move the database files to Azure.

You need to attach the database files to the SQL Server instance on the virtual machine. The solution must ensure that you can run file snapshot backups.

How should you complete the statement? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area: