Exam 70-764 topic 1 question 318 discussion

Actual exam question from Microsoft's 70-764

Question #: 318
Topic #: 1

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:

Show Suggested Answer

Suggested Answer:

Explanation -
✑ 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

by Guest at Nov. 25, 2019, 10:39 p.m.

Comments

Submit Cancel

Guest

Highly Voted 5 years, 5 months ago

First one should be No The server experienced a motherboard failure, so it will not be able to flush it's buffers

upvoted 8 times

V_karag

4 years, 10 months ago

sql server uses write ahead log method so before a page is changed and marked as dirty this action already written to log and can be recovered to other instances.

upvoted 2 times

Iva10

4 years, 10 months ago

Motherboard failure is equivalent to lose power, and write ahead log is protecting data if such event happened, so the answer is yes https://en.wikipedia.org/wiki/Write-ahead_logging

upvoted 3 times

Haidardba

4 years, 5 months ago

Yes, All dirty pages in the buffer cache are written to disk. https://www.sqlservercentral.com/forums/topic/what-happens-when-the-number-of-dirty-pages-grows-beyond-the-number-of-pages-in-the-buffer-cache

upvoted 1 times

...

Slava_bcd81

Most Recent 4 years, 7 months ago

the first is No, actually there is NVRAM memory for that case