DP-700 Ingest and Transform Data Practice Question
You are designing a data pipeline in Microsoft Fabric using Data Factory. You need to ingest data from an on-premises SQL Server database into a Lakehouse. Which integration component must be deployed to facilitate secure connectivity between the on-premises network and Microsoft Fabric?
⚠ Common exam trap
Candidates often confuse the Self-hosted Integration Runtime with Azure Integration Runtimes or VNet data gateways, forgetting that only the SHIR facilitates the secure bridge for on-premises connectivity.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Self-hosted Integration Runtime
To connect Fabric to on-premises resources, the Self-hosted Integration Runtime (SHIR) acts as the bridge. It handles data transfer across the firewall without opening inbound ports on your local network. This is a critical architectural requirement for hybrid data integration scenarios, ensuring that Fabric can reach behind the perimeter to pull data securely while maintaining strict compliance with corporate security standards for data movement.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Azure Data Gateway
Why it's wrong here
Azure Data Gateway is a legacy term often associated with Power BI enterprise gateways. While functionally similar in purpose, the correct terminology for Fabric Data Factory pipelines is the Self-hosted Integration Runtime, which specifically manages the data movement activities across diverse cloud and hybrid network environments.
- ✓
Self-hosted Integration Runtime
Why this is correct
The Self-hosted Integration Runtime is the required software component installed on an on-premises machine or a virtual machine inside a private network. It enables the Fabric Data Factory service to securely access and move data from local sources to the Lakehouse without compromising network security posture.
- ✗
Managed Virtual Network
Why it's wrong here
Managed Virtual Networks in Fabric provide isolated environments for pipeline execution. However, they are not a substitute for the Self-hosted Integration Runtime, as they cannot reach into an on-premises network directly without the SHIR acting as the gateway for the data movement process within the pipeline.
- ✗
Azure ExpressRoute
Why it's wrong here
ExpressRoute provides a dedicated private physical or logical connection between your local network and Microsoft Azure. While it provides network connectivity, it does not function as the integration service required by Data Factory to orchestrate the actual data ingestion tasks from the SQL Server database.
About these practice questions
Courseiva writes every DP-700 question from scratch — 152 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Microsoft exam blueprint
This DP-700 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-700 exam.