Microsoft DP-300 Practice Test - Questions Answers, Page 28

You have an Azure subscription.

You need to deploy two instances of SQL Server on Azure virtual machines in a highly available configuration that will use an Always On availability group. The solution must meet the following requirements:

• Minimize how long it takes to fail over.

• Maintain existing connections to the primary replica during a failover.

What should you do?

HOTSPOT

You have an Azure SQL database named DB1 that contains a table named Table 1.

You run a query to load data into Table1.

The performance metrics of Table1 during the load operation are shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.

HOTSPOT

You have an Azure SQL database named DB1 in the General Purpose service tier.

You need to monitor DB1 by using SQL insights.

What should you include in the solution? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

HOTSPOT

You have an Azure subscription that contains an instance of SQL Server on Azure Virtual Machines.

The virtual machine hosts a database named DB1. You need to monitor DB1 by using Extended Events. The solution must meet the following requirements:

• Capture raw event data and store the data in Azure Storage.

• Minimize the performance impact of capturing extended events.

How should you complete the Transact-SQL statement? To answer, select the appropriate options in

the answer area.

NOTE: Each correct selection is worth one point.

You have an Azure SQL database.

You need to implement a disaster recovery solution that meets the following requirements:

• Minimizes how long it takes to recover the database if a datacenter fails

• Minimizes administrative effort

What should you include in the solution?

HOTSPOT

You have an Azure subscription.

You plan to migrate 10 on-premises Microsoft SQL Server instances to Azure.

You need to ensure that the migrated environment can be managed by using multiserver

administration and supports master/target (MSX/TSX) jobs. The solution must minimize

administrative effort.

Which SQL deployment options should you select as the master server (MSX) and the target server

(TSX)? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have an Azure subscription that contains an instance of SQL Server on an Azure virtual machine

named SQLVM1 and a user named User1. SQLVM1 hosts a database named DB1.

You need to ensure that User! can create a scheduled task to perform a full backup of DB1. The

solution must use the principle of least privilege.

Which built-in database role should you assign to User1?

You have an on-premises datacenter that contains a 2-TB Microsoft SQL Server 2019 database named

DB1.

You need to recommend a solution to migrate DB1 to an Azure SQL managed instance. The solution

must minimize downtime and administrative effort.

What should you include in the recommendation?

You have an Azure subscription that contains 50 instances of SQL Server on Azure Virtual Machines.

The instances host 500 Azure SQL databases. You need to ensure that all the databases have the

same configuration. The solution must meet the following requirements:

• Auditing must be enabled.

• Azure Defender must be enabled.

• Public network access must be disabled.

• Administrative effort must be minimized.

Which two resources should you create in the subscription? Each correct answer presents part of the

solution. NOTE: Each correct selection is worth one point.