SnowPro Core Certification — Question 557

What does a Query Profile provide in Snowflake?

Answer options

• 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.

Correct answer: C

Explanation

The correct answer is C, as a Query Profile visually depicts the key elements of the processing plan for a query, aiding in understanding its execution. Option A describes the query steps but does not focus on the graphical aspect, while B refers to a pre-computed dataset, and D pertains to execution time representation, neither of which encapsulate the essence of a Query Profile.