You work for MDFT Pro, a well-known training agency that operates a bike-sharing program for students and staff across multiple campus locations. Mark, a Data Engineer at MDFT Pro, has been asked to create a real-time monitoring system for bike availability. The company uses a Fabric eventstream to capture bike location data and load it into a table called Bike_Location in a KQL database. The table tracks bike stations across different campus neighborhoods, recording the number of available bikes and empty docking spaces at each location. Mark needs to create a query that filters and transforms this streaming data to show bike stations in the Sands End campus area where there are at least 15 bikes available, with results ordered by the number of bikes. He plans to use the following SQL code to accomplish this:
SELECT BikepointID, Street, Neighbourhood, No_Bikes, No_Empty_Docks, Timestamp
FROM bike_location
WHERE neighbourhood = 'Sands End'
AND no_bikes >= 15
ORDER BY no_bikes
Does this SQL-based solution meet the goal of querying and transforming the data in the KQL database?
Choose the correct answer from the options below.
Explanations for each answer: