nerdexam
Microsoft

DP-300 · Question #24

You need to recommend an availability strategy for an Azure SQL database. The strategy must meet the following requirements: - Support failovers that do not require client applications to change…

The correct answer is D. geo-replication. Active geo-replication is an Azure SQL Database feature that allows you to create readable secondary databases of individual databases on a server in the same or different data center Incorrect Answers: C: Availability Zones are unique physical locations within a region. Each…

Submitted by dimitri_ru· Mar 6, 2026Plan and implement a HADR environment

Question

You need to recommend an availability strategy for an Azure SQL database. The strategy must meet the following requirements: - Support failovers that do not require client applications to change their connection strings. - Replicate the database to a secondary Azure region. - Support failover to the secondary region. What should you include in the recommendation?

Options

  • Afailover groups
  • Btransactional replication
  • CAvailability Zones
  • Dgeo-replication

How the community answered

(25 responses)
  • A
    8% (2)
  • B
    16% (4)
  • C
    4% (1)
  • D
    72% (18)

Explanation

Active geo-replication is an Azure SQL Database feature that allows you to create readable secondary databases of individual databases on a server in the same or different data center Incorrect Answers: C: Availability Zones are unique physical locations within a region. Each zone is made up of one or more datacenters equipped with independent power, cooling, and networking. https://docs.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-300 Practice