AZ-305 Design business continuity solutions

For cost and security, the team must test failover for SQL databases. What is the recommended approach?

Multiple choice — select one answer

Answer choices

  1. a. Azure Site Recovery
  2. b. Azure SQL failover groups
  3. c. Manual USB (not recommended for production workloads)
  4. d. Azure Backup recovery services vault

Architectural breakdown & explanation

Failover groups provide DR for SQL.

Correct answer(s): b. Azure SQL failover groups

Exam domain: Design business continuity solutions (10% weight on the official guide).

Official documentation & study links

Practice this certification

This page is one question from the Microsoft Azure Solutions Architect Expert bank. Run a full timed practice exam with domain-weighted random questions in your browser.