DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric

By Microsoft · Question Mode

QuestionQ26

VerifiedIngest and transform data

You have a Fabric eventstream that loads data into a table named Bike_Location in a KQL database. The table includes 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 sorted by No_Bikes in ascending order.

Solution: You use the following code segment:

Question Image

Does this satisfy the goal?

Explanation

In KQL, the sort operator defaults to descending order, not ascending. The provided code does not include the 'asc' keyword, so it sorts in descending order by default—the opposite of the stated requirement. The double project statements do not correct this fundamental sort behavior.

Community Discussion

No comments yet. Be the first to start the discussion!