You are planning disaster recovery for the failover group of an Azure SQL Database managed instance.
Your company's SLA requires that the database in the failover group become available as quickly as possible if a major outage occurs.
You set the Read/Write failover policy to Automatic.
What are two results of the configuration? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
In the event of a datacenter or Azure regional outage, the databases will fail over automatically if the Read/Write failover policy is set to Automatic. This setting ensures continuous availability by automatically redirecting to the secondary instance without manual intervention. Additionally, when an outage occurs, the databases in the primary instance will initiate an immediate failover process to maintain service availability, leveraging the automatic failover configuration for minimal downtime.
answer is right, there is grace period of an hour in geo redundancy
your argument is not valid since geo-replication is not supported by Azure SQL Managed Instance but Auto Failover groups is supported
A and E are correct. Minimum grace allowed is 1 HR
A and D.
Look correct
Given answer is correct
Because verification of the scale of the outage and how quickly it can be mitigated involves human actions by the operations team, the grace period cannot be set below one hour. This limitation applies to all databases in the failover group regardless of their data synchronization state. https://docs.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-overview?tabs=azure-powershell
What about option B
Not immediately. The failover would happen after "Grace Period" (min 60 mins).