Have you failed a job interview?
Send us your job interview questions and get correct answers.

You need to recommend a disaster recovery solution for your Azure SQL database that needs to remain available even when the whole region fails. What should you include in the recommendation?

Experience Level: Senior
Tags: Azure CloudAzure SQL Database

Answer

Configure auto-failover group.

Auto-failover groups is a SQL Database feature that allows you to manage replication and failover of a group of databases on a SQL Database server or all databases in a managed instance to another region. It is a declarative abstraction on top of the existing active geo-replication feature, designed to simplify deployment and management of geo-replicated databases at scale.
Related Azure Cloud job interview questions

Comments

No Comments Yet.
Be the first to tell us what you think.
Azure SQL Database
Azure SQL Database

Are you learning Azure Cloud ? Try our test we designed to help you progress faster.

Test yourself
AZ-304 Microsoft Azure Architect Design Preparation
AZ-304 Microsoft Azure Architect Design Preparation

Are you learning Azure Cloud ? Try our test we designed to help you progress faster.

Test yourself