DP-300 Exam Question 46

You have an Azure SQL Database managed instance.
The instance starts experiencing performance issues.
You need to identify which query is causing the issue and retrieve the execution plan for the query. The solution must minimize administrative effort.
What should you use?
  • DP-300 Exam Question 47

    You have an Azure subscription that contains a logical SQL server named Serverl. The master database of Serverl contains a user named Userl. You need to ensure that Userl can create databases on Serverl. Which database role should you assign to Userl?
  • DP-300 Exam Question 48

    You plan to move two 100-GB databases to Azure.
    You need to dynamically scale resources consumption based on workloads. The solution must minimize downtime during scaling operations.
    What should you use?
  • DP-300 Exam Question 49

    You have an Azure Stream Analytics job.
    You need to ensure that the job has enough streaming units provisioned.
    You configure monitoring of the SU % Utilization metric.
    Which two additional metrics should you monitor? Each correct answer presents part of the solution.
    NOTE: Each correct selection is worth one point.
  • DP-300 Exam Question 50

    You have an Azure SQL database named DBI that contains a nonclustered index named index1.
    End users report slow queries when they use index1.
    You need to identify the operations that are being performed on the index.
    Which dynamic management view should you use?