Microsoft
DP-300 · Question #238
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 Gov
Sign in or unlock DP-300 to reveal the answer and full explanation for question #238. The question stem and answer options stay visible for context.
Submitted by helene.fr· Mar 6, 2026Optimize query performance and manage resources in Azure SQL environments - specifically configuring Resource Governor for workload isolation and CPU resource allocation in Azure SQL Managed Instance
Question
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 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. Answer:
Exhibit
Answer Area
Drag items
Create a plan.Create a classifier function in db1.Create a workload group.Create a classifier function in the master database.Create a resource pool that has the following configurations: MAX_CPU_PERCENT = 100 MIN_CPU_PERCENT = 50
Unlock DP-300 to see the answer
You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Resource Governor#Azure SQL Managed Instance#Workload Management#CPU Resource Governance