Free Microsoft DP-300 Exam Questions

You have a version-8.0 Azure Database for MySQL database.

You need to identify which database queries consume the most resources.

Which tool should you use?

You have SQL Server on an Azure virtual machine that contains a database named DB1. DB1 contains a table named CustomerPII.

You need to record whenever users query the CustomerPII table.

Which two options should you enable? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

For monitoring an HA/DR solution in Azure, which of the following tools would you utilize?

Your organization wants to deploy a SQL Server HA/DR solution in Azure. They have the following requirements:

Automatic failover without manual intervention.

Read and write operations should be possible on the primary replica, while only read operations should be allowed on the secondary replica.

Both primary and secondary replicas must reside in different Azure regions for disaster recovery purposes.

Which of the following configurations meets all the provided requirements?

You receive numerous alerts from Azure Monitor for an Azure SQL Database instance.

You need to reduce the number of alerts. You must only receive alerts if there is a significant change in usage patterns for an extended period.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.