nerdexam
Microsoft

DP-300 · Question #215

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 outa

Sign in or unlock DP-300 to reveal the answer and full explanation for question #215. The question stem and answer options stay visible for context.

Submitted by kim_seoul· Mar 6, 2026Plan and configure a high availability and disaster recovery (HA/DR) environment

Question

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 outage occurs. The Read/Write failover policy is set to Automatic. Which of the following can occur as a result of this configuration? (Select TWO)

Exhibit

DP-300 question #215 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.

Unlock DP-300 to see the answer

You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full DP-300 Practice