DP-300 Certification Practice Question #252

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?

Accepted Answer

To protect against a single datacenter (zone) failure with automatic failover and zero data loss, zone redundancy is required. Zone redundancy synchronously replicates database transactions across availability zones. In the DTU purchasing model, the Premium tier supports zone-redundant configurations, while the Basic tier does not. Therefore, Azure SQL Database Premium is the correct and most cost-effective option among the choices.

More DP-300 practice questions