Administering Relational Databases on Microsoft Azure — Question 47

You are modifying an existing disaster recovery solution for an Azure SQL managed instance that contains a failover group named FG1.

You need to ensure the maximum in-transit time for FG1 when an automatic failover oсcurs.

What should you configure?

Answer options

• A. an availability group
• B. a secondary managed instance
• C. a failover policy
• D. a grace period

Correct answer: D

Explanation

Configuring a grace period is essential because it defines the maximum time the system will wait before considering a failover complete, thereby minimizing in-transit time. Options A, B, and C do not specifically address the management of in-transit time during automatic failovers and are not relevant to this scenario.