DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric

By Microsoft · Question Mode

QuestionQ64

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: Change the join type to kind=outer.

Does this meet the goal?

Explanation

KQL does not support outer as a join flavor. Valid outer join flavors are leftouter, rightouter, and fullouter; therefore, kind=outer makes the query invalid and cannot reduce its execution time.

Learn more

Community Discussion

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