DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric

By Microsoft · Question Mode

QuestionQ25

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: Use the following code segment:

Question Image

Does this fulfill the goal?

Explanation

filter is equivalent to KQL where and retains only rows whose predicate evaluates to true; the predicate restricts results to Sands End with No_Bikes >= 15. sort by No_Bikes asc orders the retained rows from lowest to highest number of bikes. The final project retains the specified columns. [where operator — Kusto] (https://learn.microsoft.com/en-us/kusto/query/where-operator?view=microsoft-fabric) sort operator — Kusto

Learn more

Community Discussion

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