Free Preparation Discussions
MENU
Microsoft Exam DP-700 Topic 2 Question 2 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 this is an SQL-like query and cannot be executed in KQL, which is required for the database.
Correct code should look like:
Fletcher
2 months agoRachael
1 months agoReita
1 months agoLashawnda
2 months agoAlberto
2 months agoKimberely
1 months agoEarnestine
1 months agoAlba
2 months agoBrynn
2 months agoDonte
2 months agoMiesha
29 days agoTashia
1 months agoCarmelina
1 months agoSamira
2 months agoElroy
2 months agoSherita
2 months agoSharan
2 months agoHerman
2 months agoRaymon
2 months ago