Crucial Exams

Microsoft Fabric Data Engineer Associate DP-700 Practice Question

A pipeline in Microsoft Fabric contains a Dataflow Gen2 that copies daily CSV files from Azure Data Lake Storage Gen2 into a lakehouse table. Last night the vendor added two new optional columns to the CSV schema, and the pipeline run failed with the following error:

"Column count mismatch between source and sink. Column 'NewField1' not found in the sink table."

You need to modify the dataflow so that future schema-drift changes in the source files do NOT cause the pipeline to fail and new columns are ignored until the lakehouse table is manually updated. Which change should you make?

  • Enable the Dynamic schema option on the Dataflow source and leave column mapping set to auto-detect.

  • Add an Alter Row transformation that routes rows with new columns to a reject sink.

  • Turn on Detect data types in the Dataflow sink settings and refresh the schema.

  • Set the Copy activity to use a staging folder in the lakehouse before the sink.

Microsoft Fabric Data Engineer Associate DP-700
Monitor and optimize an analytics solution
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