ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 90 - AZ-305 discussion

Report
Export

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.


Question 90
Correct answer: Question 90

Explanation:

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.

Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview

asked 02/10/2024
JP Pelovello
48 questions
User
0 comments
Sorted by

Leave a comment first