Exam DP-300 topic 6 question 40 discussion

Actual exam question from Microsoft's DP-300

Question #: 40
Topic #: 6

You have an Azure SQL database named SQL1.

You need to implement a disaster recovery solution for SQL1. The solution must minimize the following:

• The recovery point objective (RPO)
• The recovery time objective (RTO)
• Administrative effort

What should you include in the solution?

A. Azure Site Recovery
B. active geo-replication
C. availability groups
D. auto-failover groups

Show Suggested Answer

Suggested Answer: D 🗳️

by OBIJUAN88 at April 27, 2023, 10:38 a.m.

Comments

Submit Cancel

bingomutant

9 months ago

D - D. auto-failover groups Here’s why: Auto-failover groups provide automatic failover in case of a region failure with minimal manual intervention (low administrative effort). It supports synchronous replication, which ensures a near-zero RPO (Recovery Point Objective), meaning minimal data loss in the event of a disaster. Automatic failover ensures that the RTO (Recovery Time Objective) is low, as the switch to the secondary replica happens automatically without manual intervention. It is designed specifically for Azure SQL databases and supports multiple databases within the same group, which is optimal for disaster recovery scenarios.

upvoted 1 times

...

2f5c7cd

9 months ago

Selected Answer: B

https://learn.microsoft.com/en-us/azure/site-recovery/site-recovery-sql#combining-bcdr-technologies-with-site-recovery

upvoted 1 times

bingomutant

9 months ago

Active geo-replication: While this allows for creating readable secondary replicas, it requires more administrative effort for failover, as it is not automatic like auto-failover groups.

upvoted 1 times

2f5c7cd

8 months, 2 weeks ago

Yes, D is correct, I changed my answer.

upvoted 1 times

...

OBIJUAN88

2 years, 2 months ago

Selected Answer: D

Answer correct: https://learn.microsoft.com/en-us/azure/azure-sql/database/business-continuity-high-availability-disaster-recover-hadr-overview?view=azuresql Recovery method RTO RPO Geo-restore from geo-replicated backups 12 h 1 h Auto-failover groups 1 h 5 s Manual database failover 30 s 5 s Auto fail over groups gives the lesser RPO&RTO and less administrative effor than manual fail over.

upvoted 4 times

durdic

10 months, 3 weeks ago

Well, not sure about that conclusion from your references, they do not match exactly with the answers provided. According this article I'd vote "active geo-replication" https://www.sqlshack.com/understanding-business-continuity-solutions-for-azure-sql-paas-services/ Active geo-replication supports RTO as 30 seconds and RPO as 5 seconds. Failover groups support 1 hour as RTO and 5 seconds as RPO.

upvoted 1 times

...