DP-600 · Question #214
What are the two limitations of the Visual Query Editor? (Select 2)
The correct answer is A. Only DQL statements are supported C. Visualize Results does not support SQL queries with Order By clause. Option A is correct because Visual Query Editor only supports Data Query Language statements which are read-only SELECT statements. Option C is correct because Visual Query Editor does not support SQL queries having an Order By clause. We can arrange the data in ascending or…
Question
What are the two limitations of the Visual Query Editor? (Select 2)
Options
- AOnly DQL statements are supported
- BOnly DDL and DML statements are supported
- CVisualize Results does not support SQL queries with Order By clause
- DVisualize Results does not support SQL queries with group-by-clause
How the community answered
(23 responses)- A96% (22)
- D4% (1)
Explanation
Option A is correct because Visual Query Editor only supports Data Query Language statements which are read-only SELECT statements. Option C is correct because Visual Query Editor does not support SQL queries having an Order By clause. We can arrange the data in ascending or descending order. https://learn.microsoft.com/en-us/fabric/data-warehouse/visual-query-editor
Topics
Community Discussion
No community discussion yet for this question.