Microsoft Fabric Data Engineer Associate DP-700 Practice Question
Your organization ingests click-stream events into a Microsoft Fabric Real-Time Intelligence KQL database. You must create a continuous query that calculates the total number of page views in each 30-minute interval, but the business also requires an updated result every 5 minutes so that recent trends are visible sooner. Which windowing function should you use in the KQL query to meet both requirements?
Because the calculation needs a 30-minute window that is recomputed every 5 minutes, the query must use overlapping windows. In Kusto Query Language, overlapping (or sliding) windows are implemented with the hop() windowing function, where you specify both the window duration and the hop (step) size. tumblingwindow() produces non-overlapping windows, while session_window() is driven by periods of inactivity, and prev() simply accesses the previous row rather than grouping events.
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 hop() function in KQL?
Open an interactive chat with Bash
How does hop() differ from tumblingwindow()?
Open an interactive chat with Bash
What are overlapping windows in data streams?
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 .