Ingest and transform streaming data
7 practice questions under this official exam objective (DP-700) — each with the community-verified answer, a full option-by-option explanation and instant feedback.
OneLake availability for an eventhouse copies only newly ingested data by default
When you turn on OneLake availability for an eventhouse in Microsoft Fabric, only data added to the eventhouse after the feature is enabled is made av
KQL sort defaults to descending, so ascending order requires an explicit asc modifier
In Kusto Query Language, the default sort order is descending (high to low); to return results ordered by a column in ascending order you must specify
Run T-SQL in a KQL database only by prefixing the query with a -- comment line
In a Microsoft Fabric KQL database, a query is interpreted as KQL by default. To run it as T-SQL you must begin the query with an empty T-SQL comment
KQL solution fails the goal because sort by defaults to descending order
The proposed KQL code filters bike_location for Sands End with No_Bikes >= 15 and sorts by No_Bikes without the asc modifier; the KQL sort operator re
The Group by operator provides the Standard deviation aggregation in Eventstream
To add the standard deviation of the temperature in Eventstream1, use the Group by transform operator, whose aggregation list includes Standard deviat
An eventstream filters the event hub feed to Chelsea and lands it in a lakehouse
An eventstream can ingest from the Azure event hub, apply a Filter transformation that keeps only events with Neighbourhood equal to Chelsea, and writ
An explicit asc modifier makes the KQL sort by solution meet the ascending goal
The proposed KQL code filters bike_location for Sands End with No_Bikes >= 15 and applies 'sort by No_Bikes asc'; the explicit asc modifier returns th