Exam DP-201 topic 4 question 3 discussion

Actual exam question from Microsoft's DP-201

Question #: 3
Topic #: 4

A company is developing a mission-critical line of business app that uses Azure SQL Database Managed Instance.
You must design a disaster recovery strategy for the solution/
You need to ensure that the database automatically recovers when full or partial loss of the Azure SQL Database service occurs in the primary region.
What should you recommend?

A. Failover-group
B. Azure SQL Data Sync
C. SQL Replication
D. Active geo-replication

Show Suggested Answer

Suggested Answer: A 🗳️
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 (currently in public preview for Managed Instance). It uses the same underlying technology as active geo- replication. You can initiate failover manually or you can delegate it to the SQL Database service based on a user-defined policy.
Reference:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-auto-failover-group

by DBQ at Feb. 25, 2020, 8:07 p.m.

Comments

Submit Cancel

syu31svc

Highly Voted 4 years, 6 months ago

Answer provided is correct

upvoted 11 times

...

Psycho

Highly Voted 4 years ago

Given answer is correct. "Active geo-replication is not supported by Azure SQL Managed Instance. For geographic failover of instances of SQL Managed Instance, use Auto-failover groups." https://docs.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview

upvoted 6 times

...

avix

Most Recent 4 years, 9 months ago

I think even Azure SQL DB PaaS - the answer would be fail-over group

upvoted 4 times

M0e

4 years, 7 months ago

Think so, too!

upvoted 1 times

...

DBQ

5 years, 3 months ago

Answers is Active Geo replication

upvoted 1 times

frakcha

5 years ago

Failover Group is correct, I'm sure of it.

upvoted 17 times

...

Diana_19

5 years, 3 months ago

Active geo-replication is not supported by managed instance. For geographic failover of managed instances, use Auto-failover groups https://docs.microsoft.com/en-us/azure/sql-database/sql-database-active-geo-replication

upvoted 42 times

HeB

5 years, 1 month ago

Indeed, secondly Active geo-replication does not allow automatic failover: 'The failover must be initiated manually by the application or the user. After failover, the new primary has a different connection end point.' https://docs.microsoft.com/en-us/azure/sql-database/sql-database-active-geo-replication

upvoted 2 times

...

groy

4 years, 8 months ago

wondering if you have passed the exam :p

upvoted 9 times

...