DP-700 Ingest and Transform Data Practice Question
You need to ingest data from an on-premises SQL Server database into a Fabric Lakehouse. What must be installed and configured on a local server to facilitate this connection?
⚠ Common exam trap
Candidates frequently select cloud connectors or direct network routing, forgetting that local firewall-protected databases require a dedicated gateway installed on-premises.
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
✓
On-premises Data Gateway.
The On-premises Data Gateway acts as a bridge, providing quick and secure data transfer between on-premises data (data that isn't in the cloud) and Microsoft cloud services like Fabric. It is a requirement for accessing local data sources that are not publicly accessible over the internet.
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 Factory Integration Runtime.
Why it's wrong here
While the Integration Runtime is used in Azure Data Factory (Azure service), Fabric uses the On-premises Data Gateway for local connectivity. The Gateway is the standard component across the Power Platform and Fabric for reaching back into local, non-cloud-hosted data environments.
- ✗
SQL Server Integration Services (SSIS).
Why it's wrong here
SSIS is a platform for building enterprise-level data integration and transformation solutions. While it can move data, it is not the connectivity component required by Fabric to reach into a local network; that role is specifically filled by the On-premises Data Gateway.
- ✓
On-premises Data Gateway.
Why this is correct
The On-premises Data Gateway is the essential software required to connect Fabric services like Dataflows and Pipelines to local data sources. It handles the secure communication tunnel and encryption necessary to extract data from a local SQL Server and move it into OneLake.
- ✗
Microsoft Entra Connect.
Why it's wrong here
Microsoft Entra Connect (formerly Azure AD Connect) is used to synchronize identity data between on-premises Active Directory and Microsoft Entra ID. It manages user accounts and authentication but does not provide a data transport path for ingesting database records into Fabric Lakehouses.
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.