What should you include in the recommendation?

You need to recommend a solution for the deployment of SQL Server 2014. The solution must meet the business requirements.

What should you include in the recommendation?
A . Create a new instance of SQL Server 2014 on the server that hosts the SQL Server 2008 instance.
B . Upgrade the existing SQL Server 2008 instance to SQL Server 2014.
C . Deploy two servers that have SQL Server 2014 installed and implement Failover Clustering.
D . Deploy two servers that have SQL Server 2014 installed and implement database mirroring.

View Answer

Answer: C

Explanation:

Scenario: The databases must be available if the SQL Server service fails.