Your company has an Azure SQL Database instance. This database is going to be added to a failover group. It has to be ensured that the database becomes available as quickly as possible if a major…

Question

Exhibit

Options

• AIf a dataceter or Azure regional outage does occur , then the databases can fail over automatically.
• BIf an outage does occur , then the databases in the primary instance can fail over immediately.
• CIf an outage does occur, you can selectively failover databases
• DIf an outage does occur, you can set a different grace period to fail over each database.

• A
  74% (29)
• B
  8% (3)
• C
  18% (7)

Explanation

If you set the Read/Write failover policy as Automatic, in the event of a datacenter or Azure regional outage, the databases will failover automatically. For Automatic failover, you can also set the Read/Write grace period as shown below. Option B is incorrect because this is based on a dataceter or Azure regional outage Option C is incorrect since the policy is set as Automatic, so the databases can't be failed over https://docs.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group- overview?tabs=azure-powershell

No community discussion yet for this question.