Microsoft
DP-300 · Question #365
You have an Azure SQL database named DB1. You need to ensure that DB1 will support automatic failover without data loss if a datacenter fails. The solution must minimize costs. Which deployment option
Sign in or unlock DP-300 to reveal the answer and full explanation for question #365. The question stem and answer options stay visible for context.
Submitted by eva_at· Mar 6, 2026Plan and configure a high availability and disaster recovery (HA/DR) environment
Question
You have an Azure SQL database named DB1. You need to ensure that DB1 will support automatic failover without data loss if a datacenter fails. The solution must minimize costs. Which deployment option and pricing tier should you configure?
Options
- AAzure SQL Database Premium
- BAzure SQL Database Basic
- CAzure SQL Database managed instance General Purpose
- DAzure SQL Database Hyperscale
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.