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?

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?

Accepted Answer

B. No The partial code segment "bike_" does not contain the necessary KQL operators (like 'where' or 'order by') or table references to filter data for "Sands End" or No_Bikes >= 15, nor can it order the results by No_Bikes ascending. Therefore, it fails to meet any of the specified requirements for data transformation and filtering.

Answer

A. Yes The incomplete code segment "bike_" does not perform any of the required filtering or ordering operations.

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…

Question

Options

How the community answered

Why each option

Community Discussion