Administering a SQL Database Infrastructure — Question 38

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

Correct answer: B

Explanation

The best option is SQL Server 2014 Standard because it provides the necessary features for high availability at a lower cost compared to Enterprise. While SQL Azure is a viable alternative, it may incur higher costs and potential configuration complexities. SQL Server 2014 Express with Advanced Services is limited in scalability and performance, making it unsuitable for the requirements of a large event.