DP-300 Certification Practice Question #129

Question

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.
Select and Place:

Accepted Answer

Configuring Resource Governor to limit CPU and memory allocation for applications on SQL Server/Managed Instance requires creating its components in a logical hierarchy. First, you must create a Resource Pool to define the physical boundaries (CPU/memory percentages). Second, you create a Workload Group to group session requests and map them to the resource pool. Third, you write a user-defined classifier function that evaluates incoming connection metadata (like application name) and routes the session to the workload group. Fourth, you modify Resource Governor to register the classifier function and reconfigure it.

More DP-300 practice questions