Microsoft Azure Architect Technologies (AZ-300) Practice Exam 2025 - Free AZ-300 Exam Questions and Study Guide

The Azure SQL Database service requires manual setup for geo-replication, which allows you to create readable secondary databases in different regions. This is an important feature for enhancing the availability of your applications while ensuring minimal latency for users distributed around the globe.

When geo-replication is enabled in Azure SQL Database, it allows for the asynchronous replication of transaction logs to a secondary database in a different geographic region. To configure this, you must manually specify the target server and the database that will serve as the secondary. This gives you the flexibility to manage and monitor the replication process according to your application’s needs.

In contrast, Azure Cosmos DB and Azure Storage provide options for automatic geo-replication as part of their offerings. Azure Recovery Services focuses on backup and disaster recovery rather than traditional database functionalities. This contextual understanding highlights the unique requirement of manual setup for geo-replication specifically in Azure SQL Database.