DP-300 Exam Question 16

You have an Azure SQL managed instance named SQLMI1 that has Resource Governor enabled and is used by two apps named App1 and App2.
You need to configure SQLMI1 to limit the CPU and memory resources that can be allocated to App1.
Which four 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 17

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 18

    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 19

    You deploy a database to an Azure SQL Database managed instance.
    You need to prevent read queries from blocking queries that are trying to write to the database.
    Which database option should set?
  • DP-300 Exam Question 20

    You are building an Azure Stream Analytics job to retrieve game data.
    You need to ensure that the job returns the highest scoring record for each five-minute time interval of each game.
    How should you complete the Stream Analytics query? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.