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 3 Discussion

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

Filter Condition: It correctly filters rows where Neighbourhood is 'Sands End' and No_Bikes is greater than or equal to 15.

Sorting: The sorting is explicitly done by No_Bikes in ascending order using sort by No_Bikes asc.

Projection: It projects the required columns (BikepointID, Street, Neighbourhood, No_Bikes, No_Empty_Docks, Timestamp), which minimizes the data returned for consumption.


Contribute your Thoughts:

Titus
15 days ago
I agree, the solution meets the goal of filtering and ordering the data as required.
upvoted 0 times
...
Refugia
15 days ago
I think the code segment is correct because it orders the results by No_Bikes in ascending order.
upvoted 0 times
...
Titus
17 days ago
Yes, the code segment filters data for Sands End with at least 15 bikes.
upvoted 0 times
...
Lorenza
18 days ago
I agree with Dewitt. The code needs to include a filter for No_Bikes >= 15 to fully meet the goal.
upvoted 0 times
Alisha
8 days ago
A) Yes
upvoted 0 times
...
...
Dewitt
24 days ago
Hmm, I'm not so sure. Shouldn't we also check if the No_Bikes value is at least 15? The question specifically mentioned that requirement.
upvoted 0 times
...
Lang
28 days ago
The code segment looks good to me. It filters the data for the Sands End neighborhood and orders the results by the No_Bikes column in ascending order, which meets the stated goal.
upvoted 0 times
Juan
10 days ago
The code segment looks good to me. It filters the data for the Sands End neighborhood and orders the results by the No_Bikes column in ascending order, which meets the stated goal.
upvoted 0 times
...
Lenna
17 days ago
A) Yes
upvoted 0 times
...
...

Save Cancel