DP-700 Exam QuestionsBrowse all questions from this exam

DP-700 Exam - Question 75


Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

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

Reference contains reference data in the following format.

Both tables contain millions of rows.

You have the following KQL queryset.

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

Solution: You move the filter to line 02.

Does this meet the goal?

Show Answer
Correct Answer:

Discussion

3 comments
Sign in to comment
GHill1982Option: A
Jan 1, 2025

Yes. By applying the `where` clause early in the query, you reduce the number of rows processed in subsequent operations, which improves performance.

vigaroOption: A
Mar 21, 2025

reduce early the data

13d2a97Option: A
Apr 20, 2025

In Kusto Query Language (KQL), the placement of the where (filter) clause significantly affects performance, especially with large datasets.