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
You need to make sure that your Azure SQL Database backups will be retained for at least 5 years. How will you solve this requirement?
Azure CloudAzure SQL Database SeniorYou run application on Azure virtual machine. You need to ensure that the application will run even when a single data center fails. How will you solve this requirement?
Azure CloudAzure Virtual Machines SeniorYou need to recommend a disaster recovery solution for your Azure CosmosDB database that needs to remain available even when the whole region fails. What should you include in the recommendation?
Azure CloudAzure Cosmos DB SeniorYou need to design a backup solution for Azure SQL Database that will store backups that can be restored for up to 5 years. What solution will you recommend?
Azure CloudAzure SQL Database SeniorWhat is a difference between Azure SQL Database vCore and DTU purchase model?
Azure CloudAzure SQL Database Senior