DP-700 · Question #50
DP-700 Question #50: Real Exam Question with Answer & Explanation
Sign in or unlock DP-700 to reveal the answer and full explanation for question #50. The question stem and answer options stay visible for context.
Question
You have a Fabric eventhouse that contains an KQL database. The database contains a table named TaxiData. The following is a sample of the data in TaxiData. VendorID tpep_pickup_datetime tpep_dropoff_datetime passenger_count trip_distance PULocationID DOLocationID payment_type total_amount 2 08T11:08:33Z 2022-06-08T11:22:17Z 1 0.17 231 50 2 7.12 1 08T11:12:05Z 2022-06-08T11:20:43Z 1 1.02 161 163 1 10.56 2 08T11:15:00Z 2022-06-08T11:25:32Z 1 1.07 142 230 2 17.12 1 08T11:29:54Z 2022-06-08T11:49:34Z 2 2.07 162 236 2 12.01 1 08T11:50:50Z 2022-06-08T12:07:24Z 2 2.65 140 142 1 7.89 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 position.
Unlock DP-700 to see the answer
You've previewed enough free DP-700 questions. Unlock DP-700 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.