HOTSPOT
A company has an on-premises Microsoft SOI Server environment and Microsoft Azure SQL
Database instance’s. 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 the secondary replied 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.
Answer:
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?