nerdexam
Microsoft

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…

Submitted by rania.sa· Apr 18, 2026Explore and analyze data

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)
  • A
    96% (22)
  • D
    4% (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

#Visual Query Editor#Query Limitations#Data Visualization#SQL Endpoint

Community Discussion

No community discussion yet for this question.

Full DP-600 Practice