DP-300 Certification Practice Question #240

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 support automatic failover with zero data loss (RPO = 0) during a datacenter failure, the database must run in a service tier that supports synchronous replication across availability zones (zone redundancy). The Business Critical tier in the vCore-based purchasing model utilizes a cluster of database replicas (similar to Always On Availability Groups) with synchronous replication, ensuring that transactions are not committed until they are hardened on the replicas. This guarantees zero data loss and rapid automatic failover. The Standard tier does not support these features, and Managed Instance General Purpose uses remote storage with single-node compute, which incurs data loss risk and higher recovery times. Therefore, Business Critical is the correct choice to meet the zero data loss and automatic failover requirements.

More DP-300 practice questions