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…

Question

Options

• AIn the event of a datacenter or Azure regional outage, the databases will fail over automatically.
• BIn the event of an outage, the databases in the primary instance will fail over immediately.
• CIn the event of an outage, you can selectively fail over individual databases.
• DIn the event of an outage, you can set a different grace period to fail over each database.
• EIn the event of an outage, the minimum delay for the databases to fail over in the primary instance

• A
  50% (20)
• B
  30% (12)
• C
  8% (3)
• D
  13% (5)

Explanation

A: Auto-failover groups allow you to manage replication and failover of a group of databases on a server or all databases in a managed instance to another region. E: 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 Incorrect Answers: C: individual SQL Managed Instance databases cannot be added to or removed from a failover https://docs.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-overview

No community discussion yet for this question.