You have 100 SQL Server Integration Services (SSIS) packages configured to use 10 on-premises SQL Server databases as their destinations. You plan to migrate those 10 databases to Azure SQL Database. Recommend a solution that allows the existing SSIS packages to target Azure SQL Database as their destinations. What should you include in the recommendation?
Choose an answer
Tap an option to check your answer.
Correct answer: Azure Data Factory.
Why this is the answer
Azure Data Factory (ADF) is the correct choice because it provides a native and scalable environment for running SSIS packages in Azure. Specifically, you can provision an Azure-SSIS Integration Runtime within ADF, which allows you to lift and shift your existing SSIS packages to Azure without extensive re-engineering. This runtime can then connect to your Azure SQL Databases as destinations. Data Migration Assistant (DMA) and SQL Server Migration Assistant (SSMA) are tools primarily used for assessing and migrating database schemas and data, not for running SSIS packages. Azure Data Catalog is a metadata management service for discovering and understanding data sources, not for executing data integration workflows.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed