Microsoft Azure Solutions Architect Expert AZ-305 Practice Question

An auto-failover group asynchronously replicates the primary database to a geo-secondary in another Azure region and can automatically fail over if the primary region becomes unavailable, giving the Business Critical tier an RPO of roughly 5 seconds-well within the 5-minute data-loss requirement. Extending the built-in automated backup retention to 35 days preserves the continuous backup chain, enabling true point-in-time restores for any moment in that 35-day window so administrators can recover from accidental deletions detected up to 25 days later. Zone redundancy addresses only single-zone failures, temporal tables do not protect against regional outages, long-term backup retention stores weekly full backups without point-in-time granularity, and protecting SQL Server on IaaS VMs with log shipping and Azure Site Recovery adds significant operational overhead and is not fully managed.