Administering Relational Databases on Microsoft Azure — Question 69

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?

Answer options

• A. Azure SQL Database managed instance General Purpose
• B. Azure SQL Database Hyperscale
• C. Azure SQL Database Premium
• D. Azure SQL Database managed instance Business Critical

Correct answer: C

Explanation

The correct answer is C, Azure SQL Database Premium, which is designed for high availability and supports automatic failover with no data loss. The other options either do not provide the required failover capabilities or are more expensive, making them less suitable for minimizing costs.