HOTSPOT

HOTSPOT
A company has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts several customer databases.
You configure instances for a specific customer as an Always On Availability Group. The primary replica is located on-premises and the secondary replica is in Azure.
You need to configure the availability group for planned manual failovers and forced failovers.
In the table below, identify the failover mode that you must use for each failover type.
NOTE: Make only one selection in each column.
Hot Area:

Correct Answer:

Explanation/Reference:
Explanation:
Column 1: Asynchronous-commit
Asynchronous-commit replicas support only the manual failover mode.
Column 2: Synchronous-commit
Synchronous-commit replicas support two settings automatic or manual. The "automatic" setting supports both automatic failover and manual failover.
Three forms of failover exist: automatic failover (without data loss), planned manual failover (without data loss), and forced manual failover (with possible data loss), typically called forced failover.
References: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/failover-and-failover-modes-always-on-availability-groups?