DP-300 Certification Practice Question #214

Question

You are building a database backup solution for a SQL Server database hosted on an Azure virtual machine.
In the event of an Azure regional outage, you need to be able to restore the database backups. The solution must minimize costs.
Which type of storage accounts should you use for the backups?

Accepted Answer

To protect database backups against an Azure regional outage and ensure they can be restored, the storage solution must replicate data to a secondary region. Both Geo-Redundant Storage (GRS) and Read-Access Geo-Redundant Storage (RA-GRS) meet this requirement. However, GRS (Option D) is the more cost-effective choice. While RA-GRS allows read-only access to the secondary region at all times (including before a failover), GRS allows users to initiate a customer-managed failover in the event of a primary region outage, which promotes the secondary region to primary and makes the backup data accessible for restoration. Therefore, GRS is the cheapest option that satisfies all requirements.

More DP-300 practice questions