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: A 🗳️

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 4 months, 1 week ago
Selected Answer: A
SQL By default shows ASC order
upvoted 13 times
...
JensQ
Most Recent 1 month, 3 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 3 times
...
Sher_Lock_Alexa
1 month, 3 weeks ago
Selected Answer: A
sql ASC is the default sort order
upvoted 4 times
...
fassil
2 months 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 3 times
...
JensQ
2 months ago
Selected Answer: B
"To run a T-SQL query, begin the query with an empty T-SQL comment line: --. The -- syntax tells 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 2 times
...
kostadiv
2 months, 1 week ago
Selected Answer: B
missing "--" in the beginning
upvoted 2 times
...
Zoran_S
2 months, 3 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." While the code syntax is correct it is missing the '--' in the beginning to tell KQL to run it as T-SQL. Therefor it should be incorrect
upvoted 2 times
...
Bharat
4 months, 2 weeks ago
Selected Answer: B
the answer is correct since there is no mention of 'Enable SQL Endpoint'. If it is enabled then the correct answer would have been A
upvoted 4 times
GHill1982
3 months, 4 weeks ago
In Fabric you can query a KQL database with SQL. I tested creating a new Eventhouse and ingesting an eventstream and this SQL querying functionality is available by default.
upvoted 6 times
doctordodge
3 months ago
While this is true that you can query SQL in a KQL database, don't you need some sort of signifier to let the KQL database know you want to query using SQL (using "--" before your SELECT statement)? https://learn.microsoft.com/en-us/kusto/query/t-sql?view=microsoft-fabric
upvoted 2 times
zxc01
4 weeks ago
for default setting on KQL database, you can execute sql code directly and don't need using "--".
upvoted 1 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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago