exam questions

Exam DP-700 All Questions

View all questions & answers for the DP-700 exam

Exam DP-700 topic 1 question 33 discussion

Actual exam question from Microsoft's DP-700
Question #: 33
Topic #: 1
[All DP-700 Questions]

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 Fabric eventstream that loads data into a table named Bike_Location in a KQL database. The table contains the following columns:

BikepointID -

Street -

Neighbourhood -

No_Bikes -

No_Empty_Docks -

Timestamp -

You need to apply transformation and filter logic to prepare the data for consumption. The solution must return data for a neighbourhood named Sands End when No_Bikes is at least 15. The results must be ordered by No_Bikes in ascending order.

Solution: You use the following code segment:


Does this meet the goal?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
SamuComqi
Highly Voted 3 months, 4 weeks ago
Selected Answer: B
The answer is B. No because the "sort by" is sorting values in descending order (default behavior --> https://learn.microsoft.com/en-us/kusto/query/sort-operator?view=microsoft-fabric). One should add "asc" to sort values as required. The double "project" at the end does not affect the final result
upvoted 9 times
...
benni_ale
Most Recent 2 months ago
Selected Answer: B
sort by in kql is by default in descending order
upvoted 1 times
...
MuffiSan
3 months, 1 week ago
Selected Answer: B
sort is desc by default in kql
upvoted 4 times
...
GHill1982
3 months, 4 weeks ago
Selected Answer: B
In KQL the where keyword should be used instead of filter.
upvoted 3 times
GHill1982
3 months, 4 weeks ago
Apologies, I have now learned the where and filter operators are equivalent in KQL. So the answer is correct depending on whether the duplicated project is a mistake in the question.
upvoted 1 times
GHill1982
3 months, 4 weeks ago
Also consider that the default for order by/sort by in KQL is is desc (high to low). The opposite of SQL. https://learn.microsoft.com/en-gb/kusto/query/sort-operator?view=azure-data-explorer#parameters
upvoted 1 times
GHill1982
3 months, 4 weeks ago
The duplicated project, even though not required, does however work and does not throw any errors.
upvoted 1 times
...
...
...
...
QAZdbarhate12345678
4 months ago
The provided code segment meets the goal. Breakdown: Filter Condition: The code uses filter Neighbourhood == "Sands End" and No_Bikes >= 15 to meet the requirement of filtering the data for the "Sands End" neighborhood and where No_Bikes is at least 15. Sorting: The sort by No_Bikes clause ensures that the results are ordered by No_Bikes in ascending order, which aligns with the requirement. Projection: The fields BikepointID, Street, Neighbourhood, No_Bikes, No_Empty_Docks, and Timestamp are projected, which ensures the required fields are returned for the query. Hence, the solution is correct and achieves the stated goal. The correct answer is A. Yes.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago