Home » Microsoft » 70-764 v.2 » HOTSPOT
HOTSPOT
You deploy a three node Windows Server Failover Clustering (WSFC) cluster. You configure a Microsoft SQL Server instance in failover cluster instance (FCI) mode.
You need to identify the actions that will take place if the motherboard on one server fails and automatic failover occurs.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct Answer:
Explanation/Reference:
Unless a hardware or system failure occurs, all dirty pages in the buffer cache are written to disk.
The FCI is online as long as its underlying WSFC cluster is in good quorum health (the majority of the quorum WSFC nodes are available as automatic failover targets). When the WSFC cluster loses its quorum, whether due to hardware, software, network failure, or improper quorum configuration, the entire WSFC cluster, along with the FCI, is brought offline.
References: https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/always-on-failover-cluster-instances-sql-server