Explanation:
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.
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.