Get Microsoft DP-300 Exam Dumps

You have 25 Azure SQL databases.

You need to implement a centralized database management solution that uses Transact-SQL What should you include in the solution?

You deploy an instance of SQL Server on Azure Virtual Machines named SQL1 that hosts multiple databases.

You configure the full recovery model for all the databases.

You perform a full backup of the master database on SQL1.

You need to a perform an additional backup of the master database on SQL1. The solution must minimize how long it takes to perform the backup.

Which type of backup should you perform?

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