Microsoft Fabric Data Engineer Associate DP-700 Practice Question
You author a Microsoft Fabric notebook that uses Spark Structured Streaming to read telemetry into a DataFrame named streamDf with a timestamp column eventTime. You will compute 5-minute device counts and write the result in append mode to a Delta table. Events can arrive up to 8 minutes late. To include those late events without unbounded state growth, which additional transformation should you apply before the aggregation?
In Spark Structured Streaming, state created by windowed aggregations is kept for as long as late data might still arrive for a given window. You therefore declare a watermark on the event-time column that specifies the maximum allowed lateness. A call to withWatermark("eventTime", "8 minutes") tells Spark to retain state for 8 minutes beyond each window's end time; after that, the engine can safely drop the state and any later arriving records are ignored. This satisfies the requirement to include events that arrive within eight minutes while preventing unbounded state growth.
Using a processing-time trigger controls how often results are emitted but does not bound event-time state. Setting outputMode("update") only changes what is written, not how long state is kept. dropDuplicates removes repeated rows, not state kept by aggregations.
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 a watermark in Spark Structured Streaming?
Open an interactive chat with Bash
What is the difference between a watermark and a processing-time trigger?
Open an interactive chat with Bash
Why does adding dropDuplicates not prevent unbounded state growth?
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 .