Exam DP-300 topic 1 question 58 discussion

Disregard my previous discussion, Answer that makes sense here is 1) Create a SQL 2019 AG on VM1 and then use 2) Distributed availability group for actual cutover/migration

upgrade the on-premises SQL Servers to SQL Server 2019 and use a distributed availability group for a seamless migration with minimal downtime

there is already a secondary replica in on-prem Always on AG Upgrade Sql server 2017binto 2019 DAG (Distributed AG) with clusterless configuration and amanual failover with migration purposes without downtime

https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/distributed-availability-groups?view=sql-server-ver16 "A distributed Availability group is a special type of availability group that spans two separate availability groups. The availability groups that partecipate don't need to be in the same location. They can be phisical, virtual on-permises, in the public cloud or anywhere. This includes cross-domain and even cross-platform". So the answers will be 1. Create a SQL 2019 AG on VM1 2. Distributed availability group

To prepare for the migration, you should upgrade the on-premises SQL servers to SQL Server 2019 and add a secondary replica to AG1. This will ensure that the on-premises servers are compatible with the SQL Server 2019 instance on VM1 and that AG1 can support cross-platform migration. To perform the migration, you should use a distributed availability group. This is a feature that allows you to create a distributed availability group that spans two availability groups, one on Windows and one on Linux. You can then perform a manual failover of the distributed availability group to VM1 and remove the on-premises replicas. This will minimize the downtime of DB1 during the migration.

Step 1: Create a new SQL Server 2019 instance on VM1. You can create a new SQL Server 2019 instance on VM1 by using the Azure portal, the Azure CLI, or the Azure PowerShell modules. Step 2: Use the Azure SQL Migration extension for Azure Data Studio to migrate DB1 to the new SQL Server 2019 instance on VM1.

Add a secondary replica to Ag1 and Azure migrate are correct answers basing on sql version supportability in distributed AG in below url https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/distributed-availability-groups?view=sql-server-ver16

upgrade the onprem to SQL 2019, then distributed availability group. https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/virtual-machines/sql-server-distributed-availability-group-complete-migration?view=azuresql

And upgrade of the on-premises sql server?

https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/virtual-machines/sql-server-to-sql-on-azure-vm-migration-overview?view=azuresql-vm A distributed availability group is a special type of availability group that spans two separate availability groups. The availability groups that participate in a distributed availability group don't need to be in the same location and include cross-domain support. This method minimizes downtime, use when you have an availability group configured on-premises.

https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/virtual-machines/sql-server-to-sql-on-azure-vm-migration-overview?view=azuresql-vm Azure Migrate The source server remains online and services requests while the source and destination server synchronize data allowing for an almost seamless migration.

Azure Migrate and other migration tools - https://learn.microsoft.com/en-us/training/modules/evaluate-strategies-for-migrating-to-azure-sql/4-describe-azure-database-migration-options

Availability groups - distributed https://learn.microsoft.com/en-us/training/modules/deploy-iaas-solutions-with-azure-sql/5-explain-high-availability-and-disaster-recovery-options Always On availability groups can be implemented between two or more (up to a maximum of nine) SQL Server instances running on Azure virtual machines or across an on-premises data center and Azure. https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/distributed-availability-groups?view=sql-server-ver16