DP-300 Certification Practice Question #226

Question

You plan to migrate on-premises Microsoft SQL Server databases to Azure.
You need to identify which deployment and resiliency options meet the following requirements:
✑ Support user-initiated backups.
✑ Support multiple automatically replicated instances across Azure regions.
✑ Minimize administrative effort to implement and maintain business continuity.
What should you identify? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Accepted Answer

To satisfy the requirement for user-initiated backups, the deployment option must be either Azure SQL Managed Instance or SQL Server on Azure VMs (as Azure SQL Database single database only supports automated backups). To minimize administrative effort to implement and maintain business continuity, Azure SQL Managed Instance (PaaS) is preferred over SQL Server on Azure VMs (IaaS). For SQL Managed Instance, the only multi-region replication and resiliency option supported is the **Auto-failover group** (active geo-replication is only available on Azure SQL Database single/elastic pool, and zone redundancy does not replicate data across regions). Therefore, the combination of Azure SQL Managed Instance and Auto-failover group is correct.

More DP-300 practice questions