DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric

By Microsoft · Question Mode

QuestionQ24

VerifiedImplement and manage an analytics solution

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

A KQL database requires a KQL tabular query, such as Bike_Location | where Neighbourhood == "Sands End" and No_Bikes >= 15 | order by No_Bikes asc. The SQL-style segment is not the required KQL query, uses a table identifier that differs from Bike_Location, and does not explicitly request ascending order; the KQL order by operator defaults to descending order when no direction is specified.

Learn more

Community Discussion

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