You need to migrate 10 on-premises databases to Azure SQL Database, but there are also 100 SSIS packages that are configured to use on premise servers as destinations. What will you use for migration?
Experience Level: Senior
Tags: Azure CloudAzure Data Factory
Answer
Use Azure Data Factory.
Provision Azure SSIS -IR in Azure Data Factory to host SSIS package first. Then use SSMS tool to deploy and run SSIS package.
Related Azure Cloud job interview questions
According to Microsoft Cloud Adoption Framework (CAF), what are the three specific terms related to Management phaze that can help improve conversations among business stakeholders?
Microsoft Cloud Adoption Framework (CAF) JuniorWhat are 6 key steps for establishing a management baseline according to Microsoft Cloud Adoption Framework (CAF)?
Microsoft Cloud Adoption Framework (CAF) JuniorWhat is management baseline according to Microsoft Cloud Adoption Framework (CAF)?
Microsoft Cloud Adoption Framework (CAF) JuniorWhat are the 5 disciplines of cloud governance according to Microsoft Cloud Adoption Framework (CAF)?
Microsoft Cloud Adoption Framework (CAF) JuniorIs Cloud Security Posture Management (CSPM) available for all Azure Subscriptions?
Microsoft Defender Junior