Exam DP-300 topic 3 question 20 discussion

Actual exam question from Microsoft's DP-300

Question #: 20
Topic #: 3

DRAG DROP -
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:

Show Suggested Answer

Suggested Answer:

Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/resource-governor/resource-governor?view=sql-server-ver15 https://docs.microsoft.com/en-us/sql/relational-databases/resource-governor/create-and-test-a-classifier-user-defined-function?view=sql-server-ver15

by o2091 at Nov. 13, 2021, 12:07 a.m.

Comments

Submit Cancel

CaptainJameson

Highly Voted 2 years, 3 months ago

Correct order: 1 The resource pool provides and limits the resources required by the application 2 The workload group uses the resource pool it is associated with 3 The classifier function assign the incoming session to the workload group 4 Modify resource governor to apply configuration changes

upvoted 13 times

...

voodoo_sh

Most Recent 5 months, 2 weeks ago

How to do it via T-SQL: use master CREATE RESOURCE POOL App1Pool WITH (MAX_CPU_PERCENT = 50, MAX_MEMORY_PERCENT = 50); CREATE WORKLOAD GROUP App1Group USING App1Pool; CREATE FUNCTION dbo.ClassifierFunction() RETURNS sysname WITH SCHEMABINDING AS BEGIN DECLARE @WorkloadGroup sysname; IF (APP_NAME() = 'App1') SET @WorkloadGroup = 'App1Group'; ELSE SET @WorkloadGroup = 'default'; RETURN @WorkloadGroup; END; ALTER RESOURCE GOVERNOR WITH (CLASSIFIER_FUNCTION = dbo.ClassifierFunction); ALTER RESOURCE GOVERNOR RECONFIGURE;

upvoted 1 times

...

vcloudpmp

11 months, 2 weeks ago

https://learn.microsoft.com/en-us/sql/-databases/resource-governor/create-and-test-a-classifier-user-defined-function?view=sql-server-ver16 CREATE RESOURCE POOL CREATE WORKLOAD GROUP Create the classifier function ALTER RESOURCE GOVERNOR RECONFIGURE; GO

upvoted 2 times

...