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.

Geo-replication in Azure SQL Database is necessary for which scenario?

Small scale data transactions.
Recovering from a regional outage.
Setting up automatic backups.
Performing local failovers.

The correct answer is: Recovering from a regional outage.

Geo-replication in Azure SQL Database is particularly relevant for scenarios involving the need for high availability and disaster recovery. When considering the case of recovering from a regional outage, geo-replication enables the creation of readable secondary databases in different Azure regions. This feature is vital, as it allows organizations to maintain access to their databases even if the primary region experiences a failure or outage. By having a replica in another geographical location, services can quickly switch over, minimizing downtime and ensuring that critical data remains accessible. In contrast, other scenarios such as small scale data transactions, setting up automatic backups, or performing local failovers deal with different functionalities within Azure SQL Database. Small scale data transactions do not necessitate geo-replication as it’s focused more on performance rather than availability at a region-wide level. Automatic backups are a built-in feature of Azure SQL Database and do not rely on geo-replication. Local failovers typically involve resources within the same region, focusing on maintaining availability rather than addressing inter-region discrepancies. Thus, geo-replication serves as a solution specifically designed for scenarios requiring recovery from broader, regional outages.