Need to maintain transational consistency of the data across both servers, need to achieve these goals without manual intervention

I got this question about MS SQL Server 2012 administration, two production servers in the same data center. You need to ensure that database remains available if a catastrophic server failure or a disk failure occurs.

You need to maintain transactional consistency of the data across both servers. You need to achieve these goals without manual intervention.

The correct answer for the above question is

>>

Two servers configured on the same subnet

SQL Server Availability Group configured in Synchronous-Commit Availability Mode

<<

But I think the correct answer should be

>>Two servers configured in Windows Failover Cluster in the same data center SQL Server configured as a clustered instance<<

September 14th, 2015 11:35pm

Windows Server Failover Clusters running SQL Server failover clustered instances utilize a shared storage. This means that you only have one copy of the database. It also means that the shared storage becomes a single point of failure. The question says "you need to ensure that database remains available if a catastrophic server failure or a disk failure occurs." That's why it cannot be an answer because a disk failure will not allow the failover clustered instance to come online
Free Windows Admin Tool Kit Click here and download it now
September 14th, 2015 11:50pm

Thank you very much for the answer. It is all clear now..
September 15th, 2015 1:20am