An e-commerce company loads order data into a Fabric warehouse every hour. The source table has an OrderModifiedDate column. The team wants to load only orders that have changed since the last load. What is the most efficient way to implement this incremental load?

Use a Dataflow Gen2 that loads the entire table and filters out unchanged rows after loading.

Truncate the destination table and reload all data every hour.

Use a watermark query that selects rows where OrderModifiedDate is greater than the last load timestamp and append them to the destination.

Load the entire source table into a staging table and then merge it into the destination.

A financial services company loads daily transaction data into a Fabric warehouse. The source system provides a change data capture (CDC) feed that includes inserts, updates, and deletes. The warehouse table must reflect the latest state of the source data. What should you implement to load the CDC data efficiently?

Use a MERGE statement in a stored procedure to apply inserts, updates, and deletes to the warehouse table.

Append all CDC records to the warehouse table and use a view that picks the latest version per key.

Truncate the warehouse table and reload the entire source table every time the CDC feed arrives.

Load only the inserts and updates, and ignore deletes because they are rare.

A smart-city project needs to ingest sensor data from traffic lights into Fabric for real-time monitoring. The data is sent to an event hub in JSON format. The solution must allow the data to be stored in a Lakehouse for historical analysis while also supporting live dashboards. What should you implement?

Use a SQL database in Fabric to directly query the event hub using T-SQL.

Use a Pipeline to copy the event hub data to a Lakehouse table once per day.

Use a scheduled Dataflow Gen2 to load data from the event hub every 10 minutes.

Use a Spark structured streaming job to read from the event hub and write both raw and aggregated data to Delta tables.

In an incremental load implementation, what is the purpose of storing the last watermark value after a successful load?

To determine the file format of the source data

To use it as the starting point for the next incremental load

To identify the source system that provided the data

To track the total number of rows loaded

Microsoft Certified:Fabric Data Engineer Associate

Domain 2Objective 1

Design and Implement Loading Patterns DP-700 Practice Questions (Page 3)

Part of the Ingest and transform data domain, which accounts for 30–35% of the DP-700 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~12–23 in this domain), expect 4–8 from this objective — we provide 35 practice questions to prepare you well beyond it. (estimate)

35questions here

7free pages

7concepts

30–35%of the exam

Questions 11–15

11application · medium
An e-commerce company loads order data into a Fabric warehouse every hour. The source table has an OrderModifiedDate column. The team wants to load only orders that have changed since the last load. What is the most efficient way to implement this incremental load?
Select an answer first
12application · medium
A financial services company loads daily transaction data into a Fabric warehouse. The source system provides a change data capture (CDC) feed that includes inserts, updates, and deletes. The warehouse table must reflect the latest state of the source data. What should you implement to load the CDC data efficiently?
Select an answer first
13application · medium
A smart-city project needs to ingest sensor data from traffic lights into Fabric for real-time monitoring. The data is sent to an event hub in JSON format. The solution must allow the data to be stored in a Lakehouse for historical analysis while also supporting live dashboards. What should you implement?
Select an answer first
14foundation · easy
Which T-SQL statement is commonly used in an incremental load to insert new rows and update existing rows in a single operation?
Select an answer first
15foundation · easy
In an incremental load implementation, what is the purpose of storing the last watermark value after a successful load?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-700

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-700” is a trademark of its owner, used for identification only.

Design and Implement Loading Patterns DP-700 Practice Questions (Page 3)

Questions 11–15

An e-commerce company loads order data into a Fabric warehouse every hour. The source table has an OrderModifiedDate column. The team wants to load only orders that have changed since the last load. What is the most efficient way to implement this incremental load?

Which T-SQL statement is commonly used in an incremental load to insert new rows and update existing rows in a single operation?

In an incremental load implementation, what is the purpose of storing the last watermark value after a successful load?

Keep studying — Ingest and transform data