DP-300 Exam Question 51

You have several Azure SQL databases on the same Azure SQL Database server in a resource group named ResourceGroup1.
You must be alerted when CPU usage exceeds 80 percent for any database. The solution must apply to any additional databases that are created on the Azure SQL server.
Which resource type should you use to create the alert?
  • DP-300 Exam Question 52

    You have SQL Server on an Azure virtual machine.
    You need to use Policy-Based Management in Microsoft SQL Server to identify stored procedures that do not comply with your naming conventions.
    Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

    DP-300 Exam Question 53

    You receive numerous alerts from Azure Monitor for an Azure SQL database.
    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.
  • DP-300 Exam Question 54

    You are developing an application that uses Azure Data Lake Storage Gen 2.
    You need to recommend a solution to grant permissions to a specific application for a limited time period.
    What should you include in the recommendation?
  • DP-300 Exam Question 55

    You plan to perform batch processing in Azure Databricks once daily.
    Which type of Databricks cluster should you use?