Answer-first summary for fast verification
Answer: Azure Database Migration Service, utilizing its capability for continuous data synchronization and minimal downtime migration., Azure Data Box, for physically transferring the database to Azure, ensuring data security and compliance.
Azure Database Migration Service is the recommended option for minimizing downtime and data loss during the migration, as it supports continuous data synchronization from the source to the target database before the final cutover. For scenarios where data security and compliance are paramount, especially in regulated industries, Azure Data Box can be considered for the physical transfer of data, ensuring that data does not traverse the internet and thus reducing exposure to potential threats. However, the primary focus should be on Azure Database Migration Service for its minimal downtime capabilities, with Azure Data Box as a complementary solution for specific compliance requirements.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Your team is tasked with migrating a large database from an on-premises SQL Server to Azure SQL Database. The migration must ensure minimal downtime and data loss, comply with regulatory requirements, and be cost-effective. Considering these constraints, which Azure service would you recommend for this migration? Additionally, outline the key steps involved in the migration process to ensure a smooth transition. Choose the best option from the following:
A
Azure Database Migration Service, utilizing its capability for continuous data synchronization and minimal downtime migration.
B
Azure Data Box, for physically transferring the database to Azure, ensuring data security and compliance.
C
Azure SQL Data Sync, for setting up a continuous synchronization between the on-premises SQL Server and Azure SQL Database.
D
Azure Migrate, adopting a lift and shift approach to move the database to Azure with minimal changes.
E
Both Azure Database Migration Service for minimal downtime and Azure Data Box for ensuring data security and compliance.
No comments yet.