Crucial Exams

Microsoft Fabric Data Engineer Associate DP-700 Practice Question

Your organization ingests daily CSV sales files into a Delta table in Microsoft Fabric by using a Dataflow Gen2. Some days, the upstream system resends one or more previous files, causing duplicate rows in the target table. You must modify the solution so that reprocessing the same file does not create duplicates and avoids a full table reload. What should you do?

  • Enable the Auto Compaction feature for the Delta table.

  • Add a distinct transformation on all columns in the dataflow before the sink.

  • Replace the dataflow sink with a Fabric notebook that executes a Delta MERGE statement matching on TransactionID.

  • Change the dataflow to load the files into a new table each day and use UNION ALL to combine the tables.

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