Question 20

Question

DRAG DROP You have a Fabric eventhouse that contains a KQL database. The database contains a table named TaxiData. The following is a sample of the data in TaxiData.  You need to build two KQL queries. The solution must meet the following requirements: One of the queries must partition RunningTotalAmount by VendorID. The other query must create a column named FirstPickupDateTime that shows the first value of each hour from tpep_pickup_datetime partitioned by payment_type. How should you complete each query? To answer, drag the appropriate values the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

Drew G. · Answer

RunningTotalAmount = Row_cumsum, FirstPickupDateTime = Row_window_session. Row_cumsum gives you that rolling sum partitioned on VendorID, which matches the requirement. For the hourly grouping by payment_type, row_window_session is used to grab the first pickup datetimes for each group/session window. That's how I've seen it in official Microsoft docs too, but open to other views if someone thinks different.

Liam · Answer

RunningTotalAmount = Row_cumsum, FirstPickupDateTime = Row_window_session. This matches what the official docs and labs show, at least from practice.

Sam K. · Answer

Pretty sure it's RunningTotalAmount = Row_cumsum, FirstPickupDateTime = Row_window_session. Row_cumsum does the running sum by partition, and window_session grabs the first in each time period split by payment_type. Saw similar on a practice set. If anyone thinks row_rank_min fits better, let me know.

Sara A. · Answer

Kinda confused here, but I thinkRunningTotalAmount = Row_cumsumFirstPickupDateTime = Row_window_sessionI picked window_session for the first pickup since it's about finding the start of a session (in this case, each hour by payment_type), and cumsum to get a running total by VendorID. Not 100% though, these KQL row functions always trip me up. Someone confirm?

Microsoft Data Engineering DP-700 Real Exam Questions [October 2026 Update] Quiz

Premium Access Includes