DP-700 Ingest and Transform Data Practice Question
You are configuring a Copy Activity in Fabric Data Factory to ingest data from an external REST API. Which TWO configuration settings are required to ensure data is handled correctly? (Choose two)
⚠ Common exam trap
Candidates frequently select 'Linked Service' or 'Credential' settings. While necessary for connectivity, they are not specific to the REST API data handling requirements like pagination and base URL definition.
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
✓
Pagination rules
When working with REST APIs, you must define the base URL and the pagination rules to capture the full dataset. Many APIs limit the number of records per request; therefore, setting up pagination ensures the pipeline automatically requests subsequent pages until all data is retrieved. Correct configuration of these properties is vital for robust, scalable data ingestion that avoids incomplete data loads in your lakehouse.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Pagination rules
Why this is correct
Pagination rules are essential for APIs that return paginated content. Without them, the Copy Activity will only ingest the first page of results, leading to incomplete datasets. Configuring these rules allows the activity to iterate through the API response until the entire dataset is successfully ingested into the destination.
- ✓
A valid Base URL
Why this is correct
The Base URL acts as the entry point for the REST API connection. Without a correctly formatted URL, the pipeline cannot establish contact with the source service. This is the foundational configuration setting for any REST-based ingestion activity, ensuring the pipeline knows exactly where to route the HTTP requests.
- ✗
An on-premises data gateway
Why it's wrong here
REST APIs are generally public-facing endpoints reachable via the internet. A gateway is specifically designed for local network resources. Using one for a public API adds unnecessary complexity and latency, as it routes traffic through the on-premises network instead of direct cloud-to-cloud communication via the managed service.
- ✗
A self-hosted integration runtime
Why it's wrong here
Fabric data pipelines use managed runtimes for public cloud interactions. Requiring a self-hosted runtime for a standard REST API is an incorrect pattern that introduces unnecessary management overhead. These runtimes are reserved for scenarios involving local private networks or legacy systems that cannot be accessed through standard managed cloud endpoints.
- ✗
A JSON schema definition
Why it's wrong here
While schemas are helpful for data validation, they are not strictly required for the pipeline to ingest data. The Copy Activity can infer the schema dynamically from the API response payload in most cases, making a manual schema definition an optional step rather than a mandatory configuration requirement for connectivity.
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.