QuestionQ90

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, while minimizing costs.

Which deployment option and pricing tier should you configure?

Explanation

Zone-redundant Azure SQL Database Premium places existing high-availability replicas in separate availability zones. Azure automatically promotes a synchronized replica when a datacenter or zone fails, with no expected data loss. Enabling zone redundancy for the Premium tier does not add cost because it uses the tier’s existing replicas.

Learn more

Community Discussion

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