Exam AZ-304 topic 7 question 1 discussion

Answer C: "Use SQL Server transactional replication." Requirement: "To avoid disrupting customer access, database downtime must be minimized when databases are migrated." Transactional replication to Azure SQL Database is now generally available: We are excited to announce that transactional replication to Azure SQL Database is now generally available (GA). This feature allows you to migrate your on-premises SQL Server databases to Azure SQL Databases with minimal downtime. https://azure.microsoft.com/de-de/blog/transactional-replication-to-azure-sql-database-is-now-generally-available https://devjef.wordpress.com/2016/12/08/setting-up-replication-from-on-premise-sql-server-to-azure-sql-db/

The Answer is A. - It is the only answer that meets the criteria and can be implemented with the information given in the scenario. B & D are no good as they do not meet the criteria "To avoid disrupting customer access, database downtime must be minimized when databases are migrated." C is no good. No where does it say they have VPN or expressroute to achieve this. Alos they are are not using Azure SQL this is all VMs.

Answer C: "Use SQL Server transactional replication." Requirement: "To avoid disrupting customer access, database downtime must be minimized when databases are migrated." Transactional replication to Azure SQL Database is now generally available: We are excited to announce that transactional replication to Azure SQL Database is now generally available (GA). This feature allows you to migrate your on-premises SQL Server databases to Azure SQL Databases with minimal downtime. https://azure.microsoft.com/de-de/blog/transactional-replication-to-azure-sql-database-is-now-generally-available https://devjef.wordpress.com/2016/12/08/setting-up-replication-from-on-premise-sql-server-to-azure-sql-db/ c

C SQL server transactional replication Needed to keep minimum downtime

On exam today 22-Dec-21

i think D, as minimal dowbtime accepted. Migrating from on-prem to Azure can use existing licence which will reduce cost. https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/migrate-to-vm-from-sql-server

https://docs.microsoft.com/en-us/azure/azure-sql/database/migrate-to-database-from-sql-server "There are two primary methods for migrating a SQL Server 2005 or later database to Azure SQL Database. The first method is simpler but requires some, possibly substantial, downtime during the migration. The second method is more complex, but substantially eliminates downtime during the migration." Method 2: Use Transactional Replication C is the answer

ref: https://docs.microsoft.com/en-us/azure/azure-sql/database/migrate-to-database-from-sql-server Azure Migrate and Transactional Replication are two primary methods for migrating a SQL Server 2005 or later database to Azure SQL Database. Azure Migrate is simpler but requires some, possibly substantial, downtime during the migration. Azure Site Recovery is same as Azure Migrate. I've been using ASR and Azure Migrate for years, and worked with Azure project teams. At backend, they use almost same approach and technology. If you check price of them, pricing are exactly same. When you can't afford to remove your SQL Server database from production while the migration is occurring, you can use SQL Server transactional replication as your migration solution. So C is correct.

MS actually has a very good website to help with the migration https://docs.microsoft.com/en-us/data-migration/ Select "SQL Server" to the taget, for example, azure sql database , then you will go to https://docs.microsoft.com/en-us/azure/azure-sql/migration-guides/database/sql-server-to-sql-database-overview From there, there are recommended solutions and "C" is correct.

but how do you get the database to azure to begin with? transactional replication alone doesn't migrate it. ASR allows the whole database and low RTO. it can cutover in a matter of a couple minutes.

Option D sounds correct as per this article - https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/migrate-to-vm-from-sql-server "Convert on-premises machine to Hyper-V VHDs, upload to Azure Blob storage, and then deploy a new virtual machine using uploaded VHD" Use when bringing your own SQL Server license, when migrating a database that you'll run on an older version of SQL Server, or when migrating system and user databases together as part of the migration of database dependent on other user databases and/or system databases.

Correct answer A: Use Azure Site Recovery to replicate the SQL servers to Azure You need to migrate all server ( WebApp1 + database ) to azure virtual machine so Use Azure Site Recovery to replicate the SQL servers to Azure. https://docs.microsoft.com/en-us/azure/migrate/tutorial-migrate-hyper-v?tabs=UI

Option C required SQL Server to be compatible with Azure SQL Database. https://docs.microsoft.com/en-us/azure/azure-sql/database/replication-to-sql-database In my opinion too many changes are requred. Options B, D want to move Azure SQL Database files but SQL Server files are not the same

The question concerns only with SQL Server data. So, the stated answer is correct: "Use SQL Server transactional replication."

C is good: https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/replication-transactional-overview

My opinion after reading the suggestions here, the question requirements and researching some documentation: "When you can't afford to remove your SQL Server database from production while the migration is occurring, you can use SQL Server transactional replication as your migration solution" From <https://docs.microsoft.com/en-us/azure/azure-sql/database/migrate-to-database-from-sql-server#method-2-use-transactional-replication>

Correct Answer D