DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric

By Microsoft · Question Mode

QuestionQ66

VerifiedIngest and transform data

You have a KQL database that contains two tables named Stream and Reference. Stream contains streaming data in the following format.

Scenario Image

Reference contains reference data in the following format.

Scenario Image

Both tables contain millions of rows.

You have the following KQL queryset.

Scenario Image

You need to reduce how long it takes to run the KQL queryset.

Solution: You replace project with extend.

Does this achieve the goal?

Explanation

The project operator keeps only its specified columns and drops all others, which reduces unnecessary data flowing through later query operations. The extend operator instead appends calculated columns while retaining the input columns, including the original dynamic GeoLocation value; therefore, this change does not reduce query runtime for the stated goal.

Learn more

Community Discussion

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