
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.