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…

Question

Options

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

• A
  9% (3)
• B
  17% (6)
• C
  71% (25)
• D
  3% (1)

Explanation

Explanation

Azure SQL Database Premium (Option C) supports Active Geo-Replication and Auto-Failover Groups, which provide automatic failover with zero data loss (using synchronous replication) in the event of a datacenter failure - and it does so at a lower cost than Business Critical or Managed Instance tiers.

Why the distractors are wrong:

• Option A (Managed Instance General Purpose) uses asynchronous replication and does not guarantee zero data loss during failover, making it unsuitable for this requirement.
• Option B (Hyperscale) has limited geo-replication support and is primarily designed for massive scale-out scenarios, not cost-effective failover solutions.
• Option D (Managed Instance Business Critical) does support zero data loss failover but is significantly more expensive than Azure SQL Database Premium, violating the "minimize costs" requirement.

Memory Tip: Think "Premium = Protection at a Price-conscious level" - when you see automatic failover + no data loss + minimize cost in a question, Premium tier on a single Azure SQL Database (not Managed Instance) is the sweet spot. The keyword "minimize costs" is your signal to eliminate the more expensive Managed Instance options.

No community discussion yet for this question.