SnowPro Core Certification — Question 245

What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?

Answer options

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

Correct answer: B

Explanation

The correct answer is B because an explain plan allows you to analyze the performance of a query without executing it, making it a valuable tool for optimization. Options A, C, and D are incorrect as they either misrepresent the capabilities of the explain plan or incorrectly compare it to the query profiler.