Crucial Exams

Microsoft Fabric Data Engineer Associate DP-700 Practice Question

You are creating a Microsoft Fabric Data Factory pipeline that copies data from an on-premises SQL Server table to a Lakehouse in Delta format. The source table contains an indexed LastUpdated datetime column. After a one-time historical load, the pipeline must run every hour and ingest only the rows whose LastUpdated value is greater than the maximum value processed in the previous successful run. The solution must manage the watermark automatically without any custom activities or code.

What should you do?

  • Enable the Incremental copy option in the Copy Data activity and configure the LastUpdated column as the watermark.

  • Replace the Copy Data activity with a Dataflow Gen2 configured for a full refresh of the table at each hourly run.

  • Run a pre-copy SQL script that truncates the destination table, then load the entire source table each time.

  • Pass the pipeline trigger time as a parameter to the source query and store the previous run time in Azure Key Vault by using a Web activity.

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