DP-300 · Question #473
You have an Azure SQL Database failover group named AzFG1. You plan to run the following CLI command. How will this affect AzFG1?
The correct answer is B. Automatic failover will occur after a minimum of two hours. The az sql failover-group command manages SQL Failover Groups. Parameters include: Interval in hours before automatic failover is initiated if an outage occurs on the primary server. This indicates that Azure SQL Database will not initiate automatic failover before the grace…
Question
Options
- AUp to two hours of data will be lost during an automatic failover.
- BAutomatic failover will occur after a minimum of two hours.
- CA forced failover cannot be initiated during the grace period.
- DAzFG1 will attempt to fail back within two hours.
How the community answered
(31 responses)- A6% (2)
- B90% (28)
- D3% (1)
Explanation
The az sql failover-group command manages SQL Failover Groups. Parameters include: Interval in hours before automatic failover is initiated if an outage occurs on the primary server. This indicates that Azure SQL Database will not initiate automatic failover before the grace period expires. Please note that failover operation with --allow-data-loss option might cause data loss due to the nature of asynchronous synchronization. --allow-data-loss Complete the failover even if doing so may result in data loss. This will allow the failover to proceed even if a primary database is unavailable. https://learn.microsoft.com/en-us/cli/azure/sql/failover-group?view=azure-cli-latest#az-sql- failover-group-update
Community Discussion
No community discussion yet for this question.