Sql Server Migration — Microsoft Azure Solutions Architect (AZ-305) Practice Questions
SQL Server migration to Azure involves assessing compatibility, selecting a target platform such as Azure SQL Database, Azure SQL Managed Instance, or SQL Server on Azure VMs, and then executing the migration with appropriate tooling. On the AZ-305 exam, candidates must know how to match SQL Server feature dependencies, such as cross-database queries, SQL Agent jobs, or CLR assemblies, to the correct Azure target that supports those features. Azure Migrate and the Database Experimentation Assistant help assess compatibility and predict performance at scale before migration begins. Architects are also expected to address network connectivity, authentication migration from SQL logins to Azure AD identities, and post-migration validation steps.