Microsoft DP-300 Administering Microsoft Azure SQL Solutions Exam Practice Test

You have an instance of SQL Server on Azure Virtual Machines named VM1.

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

* Returns the solution to an operational state within 15 minutes of a failure

* Can perform disaster recovery testing in an isolated environment

* Minimizes administrative effort

What should you include in the solution?

You have an Azure subscription that contains an Azure SQL database. The database contains a table named tablet.

You execute the following Transact-SQL statements.

You need to reduce the time it takes to perform analytic queries on the database.

Which configuration should you enable?

You have an on-premises datacenter that contains a 14-TB Microsoft SQL Server database.

You plan to create an Azure SQL managed instance and migrate the on-premises database to the new instance.

Which three service tiers support the SQL managed instance? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

You have an instance of SQL Server on Azure Virtual Machines named SQL1.

SQL1 contains an Extended Events session named session! that captures Microsoft SQL Server events.

You need to correlate the session events with events captured by Event Tracing for Windows (ETW).

What should you do for session1?

You have an Azure subscription that contains the following resources:

* 10 Azure SQL databases

* Five Azure SQL managed instances

* Five instances of SQL Server on Azure Virtual Machines

You need to implement a centralized monitoring solution for all the Azure SQL resources. The solution must minimize administrative effort. What should you include in the solution?

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

You need to ensure that a user named User1 can configure proxy accounts for SQL Server Agent jobs. The solution must use the principle of least privilege.

Which role should you assign to User1?

You have a Microsoft SQL Server 2019 database named DB1 and an Azure SQL managed instance named SQLMI1. You need to move a SQL Server Agent job from DB1 to SQLMI1. Which job attribute is unsupported in SQLMI1?