Have you failed a job interview?
Send us your job interview questions and get correct answers.

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

Comments

No Comments Yet.
Be the first to tell us what you think.
AZ-304 Microsoft Azure Architect Design Preparation
AZ-304 Microsoft Azure Architect Design Preparation

Are you learning Azure Cloud ? Try our test we designed to help you progress faster.

Test yourself
Azure Data Factory
Azure Data Factory

Are you learning Azure Cloud ? Try our test we designed to help you progress faster.

Test yourself