az-305 Practice Question 1966
Exam: az-305
Domain: Design business continuity solutions
Topic: Design a solution for backup and disaster recovery
Difficulty: medium
Your organization wants to ensure that their Azure SQL Database can recover from a disaster within 15 minutes, with minimal data loss. They also want to minimize costs and ensure that the database is always available in another region in case of a failure. Which Azure services should they use to achieve this goal?
Answer Options
A
Azure Backup
B
Azure Geo-Replication (GRS) for Azure SQL Database
C
Azure Site Recovery
D
Azure Data Factory
Correct Answer
B: Azure Geo-Replication (GRS) for Azure SQL Database
Explanation
The correct answer is B. Azure Geo-Replication (GRS) can achieve an RPO of less than 15 minutes by setting the replication interval to 1 minute or less. Azure SQL Database supports Geo-Replication, which allows you to replicate the database to another region for disaster recovery purposes. Option A (Azure Backup) is not designed for database-specific recovery, Option C (Azure Site Recovery) is more complex and costly for this specific requirement, and Option D (Azure Data Factory) is used for data movement rather than disaster recovery.