Free Preparation Discussions
MENU
Microsoft DP-700 Exam - Topic 2 Question 4 Discussion
Topic #: 2
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?
This code does not meet the goal because it uses order by, which is not valid in KQL. The correct term in KQL is sort by.
Correct code should look like:
Estrella
8 months agoLorriane
9 months agoMary
9 months agoJanet
9 months agoDomingo
9 months agoAlecia
10 months agoThersa
10 months agoMarva
10 months agoDeeann
10 months agoJutta
10 months agoSalome
10 months agoDoretha
10 months agoFrancesco
10 months agoTamar
2 years agoSamira
2 years agoClement
2 years agoMozelle
1 year agoLavonda
1 year agoCelestine
2 years agoJenifer
2 years agoJose
2 years agoFrance
2 years agoMargarita
2 years agoFelton
2 years agoFrance
2 years agoEdelmira
2 years agoMa
2 years agoAshton
2 years agoJohnathon
2 years agoCarman
2 years ago