DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric

By Microsoft · Question Mode

QuestionQ23

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

The filter conditions select the required neighbourhood and bike-count threshold, but order by No_Bikes defaults to descending order. The required ascending ordering would need order by No_Bikes asc.

Community Discussion

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