Microsoft DP-700 Exam - Topic 1 Question 23 Discussion

Actual exam question for Microsoft's DP-700 exam

Question #: 23
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:

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?

AYes

Bno

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

by Leatha at Nov 24, 2025, 11:14 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Yun

2 months ago

I agree with Virgie. It needs more checks.

upvoted 0 times

...

Broderick

2 months ago

But does it handle cases with fewer than 15 bikes?

upvoted 0 times

...

Clemencia

2 months ago

I believe it’s correct. It targets Sands End specifically.

upvoted 0 times

...

Wenona

2 months ago

I’m not sure. What if the ordering is wrong?

upvoted 0 times

...

Cathern

2 months ago

I think it meets the goal. The filter is clear.

upvoted 0 times

...

Merrilee

2 months ago

Yup, it returns Sands End with at least 15 bikes!

upvoted 0 times

...

Leontine

3 months ago

I think it should work, but double-check the ordering.

upvoted 0 times

...

Mertie

3 months ago

Wait, does it really order by No_Bikes?

upvoted 0 times

...

Shaun

3 months ago

Definitely meets the goal!

upvoted 0 times

...

Viola

4 months ago

The query filters by neighbourhood and checks No_Bikes.

upvoted 0 times

...

Jettie

4 months ago

Hmm, I'd have to run some performance tests to see if this is the most scalable solution. But it's a good starting point.

upvoted 0 times

...

Tonette

4 months ago

Ah, the age-old debate of efficiency vs. simplicity. I'll just sit back and enjoy the show!

upvoted 0 times

...

Joseph

4 months ago

I'm not convinced this is the best approach. There might be a more optimized way to do this.

upvoted 0 times

...

Lisha

4 months ago

This solution is perfect! It's concise and gets the job done.

upvoted 0 times

...

Caitlin

4 months ago

The code looks good, but I'm not sure if it's the most efficient way to achieve the desired result.

upvoted 0 times

...

Loise

5 months ago

I believe the solution should work if it correctly filters for Sands End and No_Bikes. But I’m a bit confused about the ordering part.

upvoted 0 times

...

Leota

5 months ago

I practiced a question like this, but I can't recall if the ordering should be done before or after filtering. That might affect the results.

upvoted 0 times

...

Cherry

5 months ago

Hmm, I'm not sure about this one. The question seems a bit tricky, and I want to make sure I fully understand what's being asked before I start coding. I might need to re-read the instructions a few times to make sure I'm on the right track.

upvoted 0 times

...

Frankie

5 months ago

This looks straightforward enough. The code provided seems to meet all the requirements, so I'm going to go with that. As long as I understand the syntax and the logic, I should be able to get this right.

upvoted 0 times

...

Dorian

5 months ago

Yes, this code segment meets the goal.

upvoted 0 times

...

Carolann

5 months ago

I'm a bit confused by the "unique solution" part of the question. Does that mean there's only one correct way to solve this, or could there be multiple valid approaches? I'll need to think carefully about my strategy here.

upvoted 0 times

...

Anabel

6 months ago

I'm not entirely sure if the filtering for No_Bikes is correct. I think it should be greater than or equal to 15, but I need to double-check the syntax.

upvoted 0 times

...

Virgie

6 months ago

I say no. The logic might miss some data points.

upvoted 0 times

...

Dawne

6 months ago

I remember a similar question where we had to filter based on multiple conditions. I think the ordering part is crucial here too.

upvoted 0 times

...

Paris

6 months ago

Okay, let me break this down step-by-step. We need to filter the data to only include the Sands End neighbourhood, where the number of bikes is at least 15, and then order the results by the number of bikes in ascending order. I think the code provided might do the trick, but I'll double-check the syntax.

upvoted 0 times

...

Irma

6 months ago

Hmm, this looks like a tricky one. I'll need to carefully read through the requirements and make sure I understand exactly what the question is asking for.

upvoted 0 times