Exam DP-700 Topic 2 Question 37 Discussion

Actual exam question for Microsoft's DP-700 exam
Question #: 37
Topic #: 2
DRAG DROP
You have a Fabric eventhouse that contains a KQL database. The database contains a table named TaxiDat a. 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.

Suggested Answer:

by Eartha at May 13, 2025, 05:14 AM

Limited Time Offer

15%

Off

Get Premium DP-700 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10