Microsoft Fabric Data Engineer Associate DP-700 Practice Question
You are building a Real-Time Intelligence solution in Microsoft Fabric. Incoming sensor events are stored in an Eventstream table that contains a timestamp column named eventTime. You must return the count of events in 2-minute windows that begin every 30 seconds so that each record can be included in multiple, overlapping windows. Which KQL windowing function should you use in the query?
The requirement calls for fixed-length windows (2 minutes) that restart every 30 seconds, causing windows to overlap. In Kusto Query Language, hopping_window() (also called hop windows) creates precisely this pattern: it produces windows of a specified length that "hop" forward by a shorter step, allowing overlap.
session_window() groups events based on periods of inactivity rather than fixed durations.
sliding_window() is not a valid KQL aggregation window function in Azure Data Explorer or Microsoft Fabric.
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 the hopping_window() function in KQL?
Open an interactive chat with Bash
How is hopping_window() different from tumbling_window()?
Open an interactive chat with Bash
Why can't session_window() or sliding_window() work in this scenario?
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 .