DP-300 Question #238: Real Exam Question with Answer & Explanation

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:

Explanation

Resource Governor in Azure SQL Managed Instance requires three sequential steps: first, create a resource pool with MIN_CPU_PERCENT=50 (guarantees at least 50% CPU always) and MAX_CPU_PERCENT=100 (allows consuming all available CPU); second, create a workload group that references the resource pool to classify and manage workload requests; third, create a classifier function in the MASTER database (not a user database) to route incoming connections to the appropriate workload group, and then register it with Resource Governor using ALTER RESOURCE GOVERNOR WITH (CLASSIFIER_FUNCTION). The classifier function must reside in master because Resource Governor is an instance-level feature that operates before database context is fully established.

No community discussion yet for this question.