DP-300 · Question #336
Case Study 5 - ADatum Corporation Overview ADatum Corporation is a financial services company that has a main office in New York City. Existing Environment Licensing Agreement ADatum has a Microsoft V
The correct answer is C. Resource Governor. Explanation Resource Governor is the correct recommendation because DB3 currently uses Resource Governor on SQL Server to manage resource allocation between App2 and App3, and Azure SQL Managed Instance and SQL Server on Azure VMs support Resource Governor - however, crucially, t
Question
Options
- Avertical scaling
- Ba custom resource pool
- CResource Governor
- Dhorizontal scaling
How the community answered
(38 responses)- A5% (2)
- B3% (1)
- C84% (32)
- D8% (3)
Explanation
Explanation
Resource Governor is the correct recommendation because DB3 currently uses Resource Governor on SQL Server to manage resource allocation between App2 and App3, and Azure SQL Managed Instance and SQL Server on Azure VMs support Resource Governor - however, crucially, the availability requirement states that DB3 must manage "potential performance issues caused by resource demand changes by App2 and App3," which maps directly to Resource Governor's purpose of classifying and limiting workloads by application. After migration to Azure SQL Database, while native Resource Governor isn't available, the question is testing recognition that this is the appropriate equivalent tool concept for managing competing resource demands between applications.
Option A (vertical scaling) is incorrect because simply scaling up compute resources doesn't address the specific need to differentiate and control resource allocation between App2 and App3 - it treats all workloads equally rather than managing competing demands.
Option B (a custom resource pool) is incorrect because custom resource pools are a component of Resource Governor, not a standalone solution - selecting Resource Governor encompasses this functionality and is the more complete, accurate answer.
Option D (horizontal scaling) is incorrect because adding more instances (sharding/read replicas) doesn't solve intra-database resource competition between two applications accessing the same database.
Memory Tip: Think "Resource Governor = Traffic Cop for workloads." When two apps compete for database resources, you need a cop to direct traffic - not a bigger road (vertical) or more roads (horizontal).
Topics
Community Discussion
No community discussion yet for this question.