Administering a SQL Database Infrastructure — Question 46

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.

Answer options

• A. Max Degree of Parallelism
• B. Resource Governor
• C. Windows System Resource Manager (WSRM)
• D. Processor affinity

Correct answer: D

Explanation

The best choice is D, Processor affinity, as it allows you to allocate specific processors to the database, ensuring high availability during the event while controlling costs. Options A, B, and C do not directly address the need for temporary, cost-effective database deployment without impacting existing applications.