70-465 Question #27: Real Exam Question with Answer & Explanation

Question

You plan to create a database. The database will be used by a Microsoft .NET application for a special event that will last for two days. During the event, data must be highly available. After the event, the database will be deleted. You need to recommend a solution to implement the database while minimizing costs. The solution must not affect any existing applications. What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.

Options

• AMax Degree of Parallelism
• BResource Governor
• CWindows System Resource Manager (WSRM)
• DProcessor affinity

Explanation

This question asks about isolating a temporary, highly available database workload without impacting existing applications, with a focus on minimizing costs. The best answer involves processor affinity to dedicate CPU resources to the new workload.

Common mistakes.

• A. Max Degree of Parallelism (MAXDOP) controls the number of processors used for parallel query execution within a single instance but does not isolate workloads between different applications or prevent resource contention from existing workloads.
• B. Resource Governor is a SQL Server feature that manages workload and resource consumption, but it requires SQL Server Enterprise Edition, which increases costs rather than minimizing them, making it a less cost-effective choice.
• C. Windows System Resource Manager (WSRM) is a Windows Server feature for managing CPU and memory allocation across processes, but it was deprecated starting with Windows Server 2012 and does not provide the database-level isolation needed for this scenario.

Concept tested. CPU isolation using processor affinity for SQL Server

Reference. https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/affinity-mask-server-configuration-option

No community discussion yet for this question.