Which High Availability Disaster Recovery (HADR) synchronization mode provides the shortest transaction
response time but has the highest probability of transaction losses if the primary system fails?

A.
SYNC (synchronous)
B.
ASYNC (asynchronous)
C.
NEARSYNC (near synchronous)
D.
SUPERASYNC (super asynchronous)
In SUPERASYNC mode, HADR EDU does the log shipping in the background, and does not interfere with the code path of the transaction, which means log shipping is out of the loop for committing transactions. Hence, it will not block the Primary from running the transactions.
0
0