An enterprise is migrating data integrations to Azure. They have: (a) dozens of existing SSIS packages that must be lifted-and-shifted with minimal changes; (b) new cloud-native transformations using mapping data flows; (c) secure connectivity to on-prem Oracle through a firewall. You plan to orchestrate with Azure Data Factory pipelines. Which two integration runtimes should you provision?
Choose an answer
Tap an option to check your answer.
Correct answer: Self-hosted integration runtime for secure connectivity to on-premises data sources, Azure-SSIS integration runtime to execute existing SSIS packages in Azure.
Why this is the answer
The scenario requires two distinct integration runtime functionalities. The Azure-SSIS integration runtime is necessary to "lift-and-shift" existing SSIS packages, allowing them to run natively in Azure Data Factory without significant modifications. The Self-hosted integration runtime is crucial for secure connectivity to on-premises data sources like Oracle, enabling data movement through a firewall. The "Azure integration runtime for cloud data movement and transformation only" is incorrect because it cannot execute SSIS packages or connect to on-premises sources securely through a firewall. "Azure Databricks interactive cluster" is not an integration runtime type for ADF pipelines in this context and is typically used for big data analytics. "SSIS catalog on SQL Managed Instance without an Azure-SSIS IR" is incorrect as an Azure-SSIS IR is required to host and execute SSIS packages in Azure Data Factory, even if the catalog is on SQL Managed Instance.
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