exam questions

Exam DP-700 All Questions

View all questions & answers for the DP-700 exam

Exam DP-700 topic 1 question 36 discussion

Actual exam question from Microsoft's DP-700
Question #: 36
Topic #: 1
[All DP-700 Questions]

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?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Mourya959595
Highly Voted 8 months ago
Selected Answer: A
SQL By default shows ASC order
upvoted 24 times
...
JensQ
Highly Voted 5 months, 2 weeks ago
Selected Answer: B
You need to use "--" to tell the KQL DB to read code as SQL. Otherwise it tries to read it as KQL
upvoted 11 times
...
e392998
Most Recent 1 week, 5 days ago
Selected Answer: B
General syntax is correct but there are typo in neighbourhood and no_bikes
upvoted 1 times
...
ziggy1117
3 weeks, 2 days ago
Selected Answer: A
I tried it in Fabric and it works. Order By is ascending order by default in SQL. (It is desc order in KQL) No need to use "--" in the Eventhouse. Also it is case insensitive so even if Neighbourhood is the column, WHERE neihborhood >=15 works
upvoted 3 times
...
norkita
1 month, 1 week ago
Selected Answer: A
A , is SQL
upvoted 1 times
...
necktru
1 month, 2 weeks ago
Selected Answer: B
Missing- - characters
upvoted 1 times
...
Delafupra
1 month, 2 weeks ago
Selected Answer: B
The query it is right, but I believe it a tricky question. The solution is not correct just for the fact that is a SQL query I believe the solution must be a KQL query
upvoted 1 times
...
smanzana
2 months ago
Selected Answer: B
It is not clear but the question states that the table is in a KQL database, so the query targets a KQL DB. Since the syntax is T-SQL, it must be prefixed with -- to work correctly.
upvoted 1 times
...
Stef6108
2 months ago
Selected Answer: A
SQL By default shows ASC order
upvoted 1 times
...
turlakDE
2 months, 1 week ago
Selected Answer: A
YES, this is SQL and order by is asc by default
upvoted 2 times
...
rohitbinnani
2 months, 1 week ago
Selected Answer: A
SQL is by-default in asc order while using order by
upvoted 2 times
...
DarioReymago
2 months, 2 weeks ago
Selected Answer: B
you have to add "--" in the beginning
upvoted 2 times
...
5dcd3a8
2 months, 4 weeks ago
Selected Answer: A
Most Probably is A the -- is not universally required for T-SQL in Fabric. It’s only required when you’re: Mixing T-SQL inside a KQL context
upvoted 2 times
...
bettermakeme
3 months ago
Selected Answer: A
SQL By default shows ASC order
upvoted 1 times
...
xmh5025
3 months, 2 weeks ago
Selected Answer: B
Remember to preface T-SQL queries with a T-SQL comment line, --, to tell the query editor to interpret the following query as T-SQL and not KQL. https://learn.microsoft.com/en-us/kusto/query/t-sql?view=microsoft-fabric#query-with-t-sql
upvoted 5 times
...
Sher_Lock_Alexa
5 months, 2 weeks ago
Selected Answer: A
sql ASC is the default sort order
upvoted 4 times
...
fassil
5 months, 3 weeks ago
Selected Answer: B
To run a T-SQL query, you need to begin the query with an empty T-SQL comment line (--). This tells the query editor to interpret the following query as T-SQL and not KQL
upvoted 5 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...