Answer-first summary for fast verification
Answer: A graphical representation of the main components of the processing plan for a query.
The Query Profile in Snowflake provides a graphical representation of the main components of the processing plan for a query, along with statistics for each component and the overall query. This is clearly documented in Snowflake's official documentation and supported by the community consensus, with option C receiving 86% of the votes. Option A is incorrect because Query Profile displays each processing step in separate panels, not the same panel. Option B describes a materialized view, not a Query Profile. Option D describes a specific feature within the Query Profile (the operator tree pane's collapsible panel), but this is only one component of the comprehensive Query Profile, not its primary purpose.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What information does a Query Profile provide in Snowflake?
A
A multi-step query that displays each processing step in the same panel.
B
A pre-computed data set derived from a query specification and stored for later use.
C
A graphical representation of the main components of the processing plan for a query.
D
A collapsible panel in the operator tree pane that lists nodes by execution time in descending order for a query.