Crucial Exams

Microsoft Fabric Data Engineer Associate DP-700 Practice Question

You maintain an Eventhouse in Microsoft Fabric Real-Time Analytics. During a nightly ingestion job that uses the 'COPY INTO' command to load parquet files from a lakehouse table, the command fails and returns the following error:

"Cannot insert the value NULL into column 'event_id'; column does not allow nulls."

You confirm that the incoming parquet files do not contain the column event_id, but the Eventhouse table schema requires the column and has no default constraint. You want to complete the load without modifying the Eventhouse table definition. Which action will resolve the error for future runs while preserving data integrity?

  • Add a column mapping in the COPY INTO command that populates event_id with a generated value (for example, newid()) for every ingested row.

  • Change COPY INTO to use the UPSERT option instead of INSERT so that missing columns are ignored.

  • Disable constraint checking by setting CHECK_CONSTRAINTS = OFF in the COPY INTO command options.

  • Alter the Eventhouse table to change event_id to allow NULL values before running COPY INTO.

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