Microsoft Azure Architect Technologies (AZ-300) Practice Exam

Disable ads (and more) with a membership for a one time $2.99 payment

Prepare for the Microsoft Azure Architect Technologies Exam with comprehensive quizzes, flashcards, and simulated questions. Master the skills required to design solutions on Azure and earn your certification efficiently!

Each practice test/flash card set has 50 randomly selected questions from a bank of over 500. You'll get a new set of questions each time!

Practice this question and more.

Which Azure database service requires manual setup for geo-replication?

Azure Cosmos DB
Azure SQL Database
Azure Storage
Azure Recovery Services

The correct answer is: Azure SQL Database

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.