70-465 · Question #41
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?
The correct answer is C. Deploy two servers that have SQL Server 2014 installed and implement Failover Clustering.. This question tests knowledge of SQL Server high availability solutions that meet business continuity requirements, specifically around automatic failover and redundancy.
Question
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.
How the community answered
(31 responses)- A3% (1)
- B16% (5)
- C74% (23)
- D6% (2)
Why each option
This question tests knowledge of SQL Server high availability solutions that meet business continuity requirements, specifically around automatic failover and redundancy.
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.
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.
Failover Clustering (Windows Server Failover Clustering with SQL Server) provides automatic failover with a shared storage architecture, ensuring high availability and meeting business requirements for minimal downtime. Two nodes in a failover cluster allow one node to take over seamlessly if the primary node fails, providing the redundancy and reliability needed for production SQL Server 2014 deployments. This is Microsoft's recommended HA solution for SQL Server when automatic failover and no data loss are required.
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
Source: https://learn.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/always-on-failover-cluster-instances-sql-server
Topics
Community Discussion
No community discussion yet for this question.