DP-300 Exam Question 106

You have an Azure subscription that contains an Azure SQL managed instance, a database named db1, and an Azure web app named Appl. Appl uses db1.
You need to enable Resource Governor for a App1. The solution must meet the following requirements:
App1 must be able to consume all available CPU resources.
App1 must have at least half of the available CPU resources always available.
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 NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

DP-300 Exam Question 107

You plan to build a structured streaming solution in Azure Databricks. The solution will count new events in fiveminute intervals and report only events that arrive during the interval.
The output will be sent to a Delta Lake table.
Which output mode should you use?
  • DP-300 Exam Question 108

    You have an Azure SQL database named DB1. You run a query while connected to DB1.
    You review the actual execution plan for the query, and you add an index to a table referenced by the query.
    You need to compare the previous actual execution plan for the query to the Live Query Statistics.
    What should you do first in Microsoft SQL Server Management Studio (SSMS)?
  • DP-300 Exam Question 109

    You have an Azure subscription that contains a logical SQL server. The server hosts two databases named db1 and db2 and an Azure AD sen/ice principal named appl.
    You need to ensure that appl can access db1. The solution must use the principle of least privilege.
    How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    DP-300 Exam Question 110

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