nerdexam
MicrosoftMicrosoft

DP-300 · Question #24

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

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 zon

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

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.

Full DP-300 PracticeBrowse All DP-300 Questions