QuestionQ118

VerifiedPlan and configure a high availability and disaster recovery (HA/DR) environment

You have an Azure SQL database called DB1.

You must ensure that DB1 supports automatic failover with no data loss if a datacenter fails. The solution must minimize costs.

Which deployment option and pricing tier should you configure?

Explanation

The Azure SQL Database Premium tier supports zone-redundant high availability, distributing synchronous replicas across availability zones. If a datacenter/availability zone fails, Azure automatically promotes a synchronized replica, so committed transactions are not lost. Premium meets this availability requirement without requiring the additional capacity or managed-instance features of the other listed options.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!