Free Preparation Discussions
MENU
Microsoft DP-700 Exam - Topic 1 Question 5 Discussion
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?
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:
Merilyn
8 months agoNydia
9 months agoMatthew
9 months agoJess
9 months agoDetra
9 months agoAimee
10 months agoKanisha
10 months agoJanessa
10 months agoJoni
10 months agoKeneth
10 months agoBobbye
10 months agoKiley
10 months agoEugene
10 months agoCathrine
10 months agoReuben
2 years agoCathern
1 year agoStephaine
1 year agoAnthony
2 years agoBrande
2 years agoLinn
1 year agoArminda
1 year agoCandra
2 years agoSharen
2 years agoDiego
2 years ago