Administering Relational Databases on Microsoft Azure — Question 4

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an Azure SQL database named Sales.
You need to implement disaster recovery for Sales to meet the following requirements:
✑ During normal operations, provide at least two readable copies of Sales.
✑ Ensure that Sales remains available if a datacenter fails.
Solution: You deploy an Azure SQL database that uses the Business Critical service tier and Availability Zones.
Does this meet the goal?

Answer options

Correct answer: A

Explanation

The solution of deploying an Azure SQL database with the Business Critical service tier and using Availability Zones does meet the requirements. It allows for multiple readable replicas and ensures high availability in case of a datacenter failure. The alternative option, 'No', is incorrect because the proposed solution adequately addresses the specified disaster recovery needs.