Courseiva

DP-300 Practice Question: Plan and configure high availability and disaster recovery

Network Topology
az sql mi showname mi1resource-group rg1query '{failoverGroup:failoverGrouplocation eastus -o yaml"failoverGroup": "/subscriptions/.../resourceGroups/rg1/providers/Microsoft.Sql/locations/eastus/failoverGroups/fg1","backupRedundancy": "Local"- databases:- db1name: fg1partnerServers:- id: /subscriptions/.../resourceGroups/rg1/providers/Microsoft.Sql/managedInstances/mi2location: westusreplicationRole: SecondaryreadWriteEndpoint:failoverPolicy: AutomaticfailoverWithDataLossGracePeriodMinutes: 60readOnlyEndpoint:failoverPolicy: DisabledreplicationRole: PrimaryreplicationState: Synchronized

Refer to the exhibit. An administrator wants to ensure that during a regional outage, the failover group automatically fails over without data loss if possible. What is the current configuration gap?

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

The backup storage redundancy is Local, which does not provide geo-redundancy for backups.

Automatic failover with data loss grace period is set to 60 minutes. The backup redundancy is Local, which means backups are stored only in the primary region. If a regional disaster occurs, backups might be lost. Geo-redundant backups would be needed to recover in the secondary region without data loss.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • The failover policy is set to Automatic, but the grace period is too long.

    Why it's wrong here

    Grace period is acceptable; the issue is backup redundancy.

  • The backup storage redundancy is Local, which does not provide geo-redundancy for backups.

    Why this is correct

    Geo-redundant backup storage (GRS) is needed to protect backups across regions.

  • The secondary managed instance mi2 is in the same region as the primary.

    Why it's wrong here

    Secondary is in westus, primary in eastus; different regions.

  • The read-only endpoint failover policy is Disabled, which prevents read-only traffic after failover.

    Why it's wrong here

    Read-only failover policy is not required for automatic failover.

About these practice questions

This DP-300 question is part of Courseiva's 906-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

JA

Written by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

This DP-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-300 exam.