Crucial Exams

Microsoft Fabric Data Engineer Associate DP-700 Practice Question

You are building a daily load from an on-premises SQL Server table into a Delta Lake table in a Microsoft Fabric lakehouse. The source table contains hundreds of millions of rows and has an incrementing bigint column named UpdateSequence that increases each time a row is inserted or modified. Loads must copy only new and changed rows, overwrite any existing versions in the destination, and be fully restartable without creating duplicate rows. Which loading pattern meets these requirements?

  • Implement a watermark-based incremental load that filters rows where UpdateSequence is greater than the last stored watermark, then upsert the data into the Delta Lake table by using MERGE INTO.

  • Schedule a nightly pipeline that truncates the Delta Lake table and performs a full bulk INSERT of the entire source table.

  • Configure two alternating pipelines: the first copies rows whose UpdateSequence modulo 2 equals 0, and the second copies the remaining rows the next day.

  • Use an eventstream to capture change events and append them directly to the Delta Lake table without performing updates.

Microsoft Fabric Data Engineer Associate DP-700
Ingest and transform data
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot