Microsoft DP-700 Exam - Topic 1 Question 5 Discussion

Actual exam question for Microsoft's DP-700 exam

Question #: 5
Topic #: 1

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?

AYes

Bno

Show Suggested 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:

by Rosalia at Jan 11, 2025, 12:05 PM

Limited Time Offer

25%

Off

Get Premium DP-700 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Merilyn

4 months ago

I think it meets the goal, nice job!

upvoted 0 times

...

Nydia

4 months ago

Wait, is Sands End even in the dataset?

upvoted 0 times

...

Matthew

4 months ago

But does it actually order by No_Bikes?

upvoted 0 times

...

Jess

4 months ago

Totally agree, that looks right!

upvoted 0 times

...

Detra

5 months ago

The query filters by No_Bikes >= 15.

upvoted 0 times

...

Aimee

5 months ago

I’m not confident about this one. I wonder if the code segment actually sorts the results as required.

upvoted 0 times

...

Kanisha

5 months ago

I feel like I’ve seen a question like this before, and I think it’s crucial to ensure the No_Bikes condition is met first.

upvoted 0 times

...

Janessa

5 months ago

I think the solution should work since it filters by No_Bikes and checks for the neighbourhood, but I’m a bit confused about the ordering part.

upvoted 0 times

...

Joni

5 months ago

I remember we practiced similar questions about filtering data in KQL, but I'm not entirely sure if the ordering is correct here.

upvoted 0 times

...

Keneth

5 months ago

This looks pretty straightforward, but I want to make sure I'm not missing anything. I'll carefully review the question and the provided code to ensure I fully understand the requirements before submitting my answer.

upvoted 0 times

...

Bobbye

5 months ago

Okay, I think I've got a good strategy here. I'll start by filtering the data to only include rows where No_Bikes is at least 15, then I'll add the neighbourhood filter and order the results. Shouldn't be too difficult.

upvoted 0 times

...

Kiley

5 months ago

The requirement to return data only for the "Sands End" neighbourhood is clear, but I'm not sure if the current query will handle that correctly. I may need to add an additional filter step.

upvoted 0 times

...

Eugene

5 months ago

Hmm, I'm a bit unsure about the syntax for the WHERE clause. I'll need to double-check the KQL documentation to make sure I'm using the right operators and conditions.

upvoted 0 times

...