Microsoft Fabric Data Engineer Associate DP-700 Practice Question
You are configuring an eventstream in Microsoft Fabric to ingest telemetry messages from Azure IoT Hub. The JSON payload occasionally receives new fields that are not yet present in your target table. You need the events to land in a lakehouse delta table with all columns available for immediate querying, while avoiding manual table-alter scripts each time the payload changes. Which eventstream setting satisfies this requirement?
Send the data to a KQL database output instead of a lakehouse table.
Enable JSON flattening and map each source property to an existing column.
Enable the schema drift option on the lakehouse output.
Define a fixed column mapping and disable automatic column creation.
Eventstreams can automatically add incoming fields to the destination table when you select the "Enable schema drift" option. With schema drift turned on, each new attribute that appears in the JSON payload is appended as a new column in the lakehouse delta table at write time, so no manual DDL changes are needed. Other settings such as flattening, specifying a fixed schema, or outputting to a KQL database do not by themselves handle evolving schemas in a lakehouse table.
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 schema drift in Microsoft Fabric eventstreams?
Open an interactive chat with Bash
What is the difference between schema drift and JSON flattening?
Open an interactive chat with Bash
Why doesn't a fixed column mapping handle new JSON payload fields?
Open an interactive chat with Bash
Microsoft Fabric Data Engineer Associate DP-700
Ingest and transform data
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 .