DP-700 Exam QuestionsBrowse all questions from this exam

DP-700 Exam - Question 74


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.

Exam DP-700 Question 74

Reference contains reference data in the following format.

Exam DP-700 Question 74

Both tables contain millions of rows.

You have the following KQL queryset.

Exam DP-700 Question 74

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

Solution: You change project to extend.

Does this meet the goal?

Show Answer
Correct Answer:

Discussion

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

No. The `project` operator is used to select specific columns, whereas `extend` is used to add new calculated columns to the result set. They serve different purposes.

vigaroOption: B
Mar 21, 2025

more data

13d2a97Option: B
Apr 20, 2025

Changing project to extend does not improve performance of a KQL (Kusto Query Language) query — in fact, it may hurt performance or keep it the same depending on the query.