What should you recommendation?

HOTSPOT

You plan to migrate on-premises Microsoft SQL Server databases to Azure.

You need to recommend a deployment and resiliency solution that meets the following requirements:

✑ Supports user-initiated backups

✑ Supports multiple automatically replicated instances across Azure regions

✑ Minimizes administrative effort to implement and maintain business continuity

What should you recommendation? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

View Answer

Answer:

Explanation:

Graphical user interface, text, application, chat or text message

Description automatically generated

Box 1: An Azure SQL Database single database.

SQL Server Managed instance versus SQL Server Virtual Machines

Active geo-replication is not supported by Azure SQL Managed Instance.

Box 2: Active geo-replication

Active geo-replication is a feature that lets you to create a continuously synchronized readable secondary database for a primary database. The readable secondary database may be in the same Azure region as the primary, or, more commonly, in a different region. This kind of readable secondary databases are also known as geo-secondaries, or geo-replicas.