Microsoft Fabric Data Engineer Associate DP-700 Practice Question
You are ingesting JSON telemetry from an Eventstream into an eventhouse table named sensor_data. The Ingestion errors pane for the eventhouse shows repeatedly Failed with error "Unknown JSON mapping "sensorMapping"". The table currently uses only the default automatic mapping. What should you do to resolve the ingestion failure and resume data flow?
Create a JSON ingestion mapping named sensorMapping on the sensor_data table that matches the structure of the incoming messages.
Set the Eventstream output format to CSV to disable JSON format detection.
Change the Eventstream sink to write the data to a lakehouse Delta table instead of the eventhouse.
Enable automatic schema update for the eventhouse so that new fields are added during ingestion.
The error message indicates that the ingestion request references a JSON mapping called sensorMapping, but no mapping with that name exists on the sensor_data table. Eventhouses (built on the Azure Data Explorer engine) require an ingestion mapping when the incoming data is JSON and a specific mapping name is supplied. Defining a JSON ingestion mapping with that exact name and column-to-path assignments lets the eventhouse correctly parse each record and the ingestion pipeline succeeds. Switching sinks, enabling automatic schema updates, or changing the output format do not address the missing mapping reference and therefore will not eliminate the error.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is JSON ingestion mapping in an eventhouse?
Open an interactive chat with Bash
How is an eventhouse different from a lakehouse Delta table?
Open an interactive chat with Bash
Why doesn't automatic schema update resolve the JSON ingestion error?
Open an interactive chat with Bash
Microsoft Fabric Data Engineer Associate DP-700
Monitor and optimize an analytics solution
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .