Explanation:
The correct answer is B because an EXPLAIN plan compiles and analyzes the SQL query without executing it, allowing for performance analysis without consuming compute credits or requiring a running warehouse. This is a key advantage over the Query Profile, which requires query execution to generate performance data. Option A is incorrect because both EXPLAIN and Query Profile provide graphical output in Snowflake. Option C is incorrect because both tools can handle queries with temporary tables. Option D is incorrect because EXPLAIN does not display automatic data skew optimization information, which is typically shown in the Query Profile after execution.
Ultimate access to all questions.
No comments yet.
What is an advantage of using an EXPLAIN plan over the Query Profile to evaluate query performance?
A
The explain plan output is available graphically.
B
An explain plan can be used to conduct performance analysis without executing a query.
C
An explain plan will handle queries with temporary tables and the query profiler will not.
D
An explain plan's output will display automatic data skew optimization information.