Crucial Exams

Microsoft Fabric Data Engineer Associate DP-700 Practice Question

You are troubleshooting an Eventstream pipeline that writes IoT telemetry into an Eventhouse in Microsoft Fabric Real-Time Analytics. The Eventstream shows a sustained "Partially succeeded" status, and the Eventhouse table's corresponding _rejects stream is rapidly growing. A sample reject record contains the errorCode "ColumnTypeMismatch" and the message "Cannot convert value 'true' from column 'isActive' to type int". What should you do to resolve the ingestion errors and stop the growth of the _rejects stream?

  • Alter the Eventhouse table to change the data type of the isActive column to bool (or add a new bool column and update the stream's column mapping) so that incoming Boolean values can be ingested.

  • Drop and recreate the _rejects stream so that it starts empty, then restart the Eventstream to re-ingest the failed events.

  • Increase the Eventhouse concurrency and throughput settings to prevent partial successes caused by throttling.

  • Convert the Boolean values to integers inside the _rejects stream using a dataflow, then append the cleaned data back into the Eventhouse table.

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