Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Azure Solutions Architect Expert · Microsoft
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
Utilize o Serviço de Migração de Banco de Dados nos seguintes cenários: migre ambos os bancos de dados para o Azure SQL, especialmente em grande escala e para migrações extensas (em termos de número e tamanho dos bancos de dados). Migre bancos de dados para o Banco de Dados do Azure.
For an offline migration of SQL1 (50 databases) to Azure SQL Managed Instance while minimizing administrative effort, the best approach is: ✅ Recommended: Azure Database Migration Service (DMS) for Offline Migration Why Azure DMS? Automates Migration Workflow – Simplifies database migration, reducing manual effort. Supports SQL Server 2008+ – Ensures seamless migration from older SQL Server versions. Preserves Schema & Data – Ensures full database structure remains intact. Offline Migration Mode – Minimizes complexity by performing a single cutover when ready.
DMA is needed if you want to assess before migration with DMS. Alternatively, if you use the Azure SQL Migration extension in Azure Data Studio, you can run assessments and migrations in a single place. The Data Migration Assistant provides seamless assessments of SQL Server on-premises and upgrades to later versions of SQL Server or migrations to SQL Server on Azure VMs or Azure SQL Database. It also help you helps you upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database.