Exam DP-300 Topic 3 Question 250 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 250
Topic #: 3
Drag and Drop Question
You have an Azure subscription that contains an Azure SQL managed instance, a database named db1, and an Azure web app named App1. App1 uses db1.
You need to enable Resource Governor for 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.

Suggested Answer:


Explanation:
Step 1: Create a resource pool that has the following configurations.
MAX_CPU_PERCENT = 100
MIN_CPU_PERCENT = 50,
Create a Resource Pool
You must define a custom resource pool that guarantees half of the CPU resources while allowing the app to scale up to the maximum available limit.
CREATE RESOURCE POOL AppCpuPool
WITH (
MAX_CPU_PERCENT = 100
MIN_CPU_PERCENT = 50,
);
Step 2: Create a workload group
You need to create a custom workload group that maps sessions to the newly created resource pool.
CREATE WORKLOAD GROUP AppWorkloadGroup
USING AppCpuPool;
Step 3: Create a Classifier Function
You must write a scalar user-defined function (UDF) in the master database to identify incoming connections from your Azure Web App (using attributes like APP_NAME() or SUSER_SNAME()).
CREATE FUNCTION dbo.rgClassifierApp()
RETURNS sysname
WITH SCHEMABINDING
AS
BEGIN
-- Checks if the application name matches your Azure Web App connection string IF (APP_NAME() = 'YourAzureWebAppName') RETURN 'AppWorkloadGroup'; RETURN 'default'; END; Reference:
https://learn.microsoft.com/en-us/sql/relational-databases/resource-governor/resource-governor-walkthrough

by Ben at Jul 13, 2026, 05:26 AM

Limited Time Offer

15%

Off

Get Premium DP-300 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10