You have an Azure subscription that contains an Azure SQL database named SQL1. SQL1 is in an Azure region that does not support availability zones. You need to ensure that you have a secondary…

The correct answer is C. active geo-replication. Active geo-replication is a feature that lets you create a continuously synchronized readable secondary database for a primary database. The readable secondary database may be in the same Azure region as the primary, or, more commonly, in a different region. This kind of…

Submitted by the_admin· Mar 6, 2026Plan and configure a high availability and disaster recovery (HA/DR) environment

Question

You have an Azure subscription that contains an Azure SQL database named SQL1. SQL1 is in an Azure region that does not support availability zones. You need to ensure that you have a secondary replica of SQLI in the same region. What should you use?

Options

Alog shipping
Bauto-failover groups
Cactive geo-replication
DMicrosoft SQL Server failover clusters

How the community answered

(50 responses)

A
10% (5)
B
2% (1)
C
82% (41)
D
6% (3)

Explanation

Active geo-replication is a feature that lets you create a continuously synchronized readable secondary database for a primary database. The readable secondary database may be in the same Azure region as the primary, or, more commonly, in a different region. This kind of readable secondary database is also known as a geo-secondary or geo-replica. https://learn.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication- overview?source=recommendations&view=azuresql

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice