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

Question

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?

Options

• ACreate a new instance of SQL Server 2014 on the server that hosts the SQL Server 2008
• BUpgrade the existing SQL Server 2008 instance to SQL Server 2014.
• CDeploy two servers that have SQL Server 2014 installed and implement Failover Clustering.
• DDeploy two servers that have SQL Server 2014 installed and implement database mirroring.

Explanation

This question tests knowledge of SQL Server high availability solutions that meet business continuity requirements, specifically around automatic failover and redundancy.

Common mistakes.

• A. Installing a new SQL Server 2014 instance on the same server as SQL Server 2008 creates a named instance but provides no high availability or redundancy since both instances share the same physical hardware and single point of failure.
• B. An in-place upgrade of SQL Server 2008 to SQL Server 2014 on a single server does not address high availability requirements, as the server remains a single point of failure with no automatic failover capability.
• D. Database mirroring was deprecated starting in SQL Server 2012 and is not a recommended solution for SQL Server 2014; additionally, it requires manual intervention for failover unless a witness server is configured, and it mirrors only individual databases rather than the entire instance.

Concept tested. SQL Server 2014 high availability using Failover Clustering

Reference. https://learn.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/always-on-failover-cluster-instances-sql-server

No community discussion yet for this question.