
Ultimate access to all questions.
You are designing an Azure Data Factory pipeline to ingest and transform data from multiple sources, including Azure Blob Storage, Azure SQL Database, and an on-premises Oracle database. The transformed data needs to be loaded into Azure Synapse Analytics. Which integration runtime would you use for each source, and how would you configure the pipeline to ensure optimal performance and security?
A
Use the default Azure Integration Runtime for all sources and configure the pipeline with default settings.
B
Use the Azure Integration Runtime for Azure Blob Storage and Azure SQL Database, and the Self-hosted Integration Runtime for the on-premises Oracle database.
C
Use the Self-hosted Integration Runtime for all sources to ensure consistent performance.
D
Use the Azure Integration Runtime for Azure Blob Storage and the Self-hosted Integration Runtime for Azure SQL Database and the on-premises Oracle database.