DP-700 · Question #55
DP-700 Question #55: Real Exam Question with Answer & Explanation
Sign in or unlock DP-700 to reveal the answer and full explanation for question #55. The question stem and answer options stay visible for context.
Question
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. You have a Fabric eventstream that loads data into a table named Bike_Location in a KQL database. The table contains the following columns: - BikepointID - Street - Neighbourhood - No_Bikes - No_Empty_Docks - Timestamp You need to apply transformation and filter logic to prepare the data for consumption. The solution must return data for a neighbourhood named Sands End when No_Bikes is at least 15. The results must be ordered by No_Bikes in ascending order. Solution: You use the following code segment: bike_location | filter Neighbourhood == "Sands End" and No_Bikes >= 15 | order by No_Bikes | project BikepointID, Street, Neighbourhood, No_Bikes, No_Empty_Docks, Timestamp Does this meet the goal?
Options
- AYes
- BNo
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.