Microsoft Certified: Azure Solutions Architect ExpertDesign business continuity solutionsHard
A healthcare organization requires a backup solution for its on-premises SQL Server databases before migrating them to Azure. The solution must support point-in-time recovery and encrypt backups at rest. Which Azure service should be used?
- AAzure Backup Server (MABS)
- BAzure Data Box
- CAzure File Sync
- DAzure Storage Account (manual backups)
Show answer & explanationAnswer & explanation
Correct answer: A. Azure Backup Server (MABS)
Azure Backup Server (MABS) extends System Center Data Protection Manager (DPM) capabilities to Azure, allowing backup of on-premises SQL Server databases directly to Azure with support for point-in-time recovery and encryption of backups at rest.
Why the other options are wrong
- B. Azure Data Box is a data transfer solution for large amounts of data, not a continuous backup solution for SQL Server databases.
- C. Azure File Sync is for synchronizing file shares, not for backing up SQL Server databases with point-in-time recovery.
- D. Using an Azure Storage Account for manual backups would require custom scripting for SQL Server, would not easily support point-in-time recovery without complex setup, and would not natively provide encryption at rest from the SQL backup process.
Azure Backup Server (MABS)
Azure Backup Server (MABS) is an enterprise-class backup solution for on-premises workloads, including SQL Server, that integrates with Azure Backup for cloud storage and recovery.
- Extends System Center Data Protection Manager (DPM) to Azure.
- Supports application-consistent backups for SQL Server.
- Enables point-in-time recovery and encryption of backups at rest.
Memory trick: MABS: Master of on-prem SQL backup to Azure.