DP-300 Certification Practice Question #238

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 SQL1 in the same region.

What should you use?

Accepted Answer

Active geo-replication in Azure SQL Database allows you to create up to four readable secondary replicas. While these are typically created in different geographic regions for disaster recovery, they can also be created in the same Azure region on a different logical server. Because SQL1 is in a region that does not support availability zones (which rules out zone-redundant high availability replicas), active geo-replication is the only supported mechanism to establish a secondary replica within the same region.

More DP-300 practice questions