🔥 3-day streak
Microsoft Fabric Analytics Engineer Associate77 / 150
Question 77 of 150
An analytics engineer is querying a KQL database in Fabric where an IoT telemetry table named DeviceEvents stores a dynamic column called Payload. Each Payload value contains nested JSON such as {"battery": {"level": 87, "charging": false}}. The engineer needs to produce a result set that returns each device's battery level as its own scalar integer column so it can be aggregated. Which KQL expression correctly extracts the battery level?
Reviewed for accuracy · Report an issueNext question