DP-300 Question #365: Real Exam Question with Answer & Explanation

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?

Options

• AAzure SQL Database Premium
• BAzure SQL Database Basic
• CAzure SQL Database managed instance General Purpose
• DAzure SQL Database Hyperscale

Explanation

The requirement is to configure an Azure SQL database named DB1 for automatic failover without data loss during a datacenter failure, while minimizing costs.

Common mistakes.

• B. The Basic tier of Azure SQL Database does not provide automatic failover with zero data loss across datacenters; its high availability model has a less robust SLA and higher Recovery Point Objective (RPO).
• C. While Azure SQL Managed Instance General Purpose can support failover groups for cross-datacenter failover, a Managed Instance is generally more expensive per database than an Azure SQL Database single database for comparable workloads, and thus might not be the most cost-effective option unless other Managed Instance-specific features are required.
• D. Azure SQL Database Hyperscale can achieve high availability and RPO 0 with multiple replicas, but it is a highly scalable and often more expensive tier designed for very large databases, which might not be the most cost-effective choice if its extensive scaling capabilities are not needed.

Concept tested. Azure SQL Database HA/DR service tiers and cost optimization

Reference. https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla

No community discussion yet for this question.