SnowPro Core Certification — Question 1222

How can a user access information about a query execution plan without consuming virtual warehouse compute resources?

Answer options

• A. Use the EXPLAIN function.
• B. Review the Query Profile metrics.
• C. Review the data in the Account_Usage view.
• D. Use the Snowsight dashboard.

Correct answer: A

Explanation

The EXPLAIN function provides insights into the query execution plan without utilizing virtual warehouse compute resources, making it the most efficient choice. The Query Profile metrics and Account_Usage view may provide useful information, but they can involve resource consumption or may not focus specifically on the execution plan. The Snowsight dashboard offers a graphical interface but does not directly provide access to the execution plan without potential resource usage.