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…

The correct answer is A. Azure SQL Database Premium. To ensure automatic failover without data loss if a datacenter fails, you should choose the Business Critical deployment option and the Premium pricing tier for the Azure SQL database named DB1. The Business Critical deployment option provides a 99.995% availability SLA, and…

Submitted by chiamaka_o· Mar 6, 2026Design and implement data storage

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 Hyperscale
CAzure SQL Database Basic
DAzure SQL Database serverless

How the community answered

(63 responses)

A
71% (45)
B
5% (3)
C
8% (5)
D
16% (10)

Explanation

To ensure automatic failover without data loss if a datacenter fails, you should choose the Business Critical deployment option and the Premium pricing tier for the Azure SQL database named DB1. The Business Critical deployment option provides a 99.995% availability SLA, and the Premium pricing tier includes features such as advanced security, high availability, and business continuity. This option also offers the ability to use a failover group with multiple readable secondary replicas.

Topics

#Azure SQL Database#high availability#failover groups#geo-replication

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice