Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam DP-700 Topic 1 Question 5 Discussion

Actual exam question for Microsoft's DP-700 exam
Question #: 5
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:

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?

Show Suggested Answer Hide Answer
Suggested Answer: B

This code does not meet the goal because it uses sort by without specifying the order, which defaults to ascending, but explicitly mentioning asc improves clarity.

Correct code should look like:


Contribute your Thoughts:

Reuben
1 months ago
I bet the exam writers are having a good laugh at our expense. This question is designed to trip us up, isn't it?
upvoted 0 times
Cathern
17 days ago
B) no
upvoted 0 times
...
Stephaine
19 days ago
I think so too. It seems like a tricky question.
upvoted 0 times
...
Anthony
1 months ago
A) Yes
upvoted 0 times
...
...
Brande
2 months ago
Frank
upvoted 0 times
Linn
27 days ago
yes
upvoted 0 times
...
Arminda
28 days ago
yes
upvoted 0 times
...
...
Candra
2 months ago
No, the code segment does not meet the goal because it does not specify the neighbourhood as Sands End.
upvoted 0 times
...
Sharen
2 months ago
I think the code segment meets the goal because it orders the results by No_Bikes in ascending order.
upvoted 0 times
...
Diego
2 months ago
Yes, the code segment filters data for Sands End with at least 15 bikes.
upvoted 0 times
...

Save Cancel