Note: This question is a part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You are designing a new high availability (HA) solution for a set of application databases. The solution will be contained within a single datacenter and provided instance-level HA protection.
You need to deploy a solution that allows for minimal downtime if the production server goes offline.
Which should you implement?
A . A Microsoft Azure Stretch Database
B . log shipping
C . an Always On Availability Group with all replicas in synchronous-commit mode
D . a file share witness
E . a Microsoft SQL Server failover cluster instance (FCI)
F . a Windows Cluster with a shared-nothing architecture
G . an Always On Availability Group with secondary replicas in asynchronous-commit mode
Answer: E
Explanation:
As part of the SQL Server Always On offering, Always On Failover Cluster Instances leverages Windows Server Failover Clustering (WSFC) functionality to provide local high availability through redundancy at the server-instance level-a failover cluster instance (FCI). References: https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/always-on-failoverÂcluster-instancessql-server