SOL-C01 Question #263: Real Exam Question with Answer & Explanation

Question

A data engineer is using the Snowflake web UI to execute a complex SQL query involving multiple joins and aggregations. The query is running slower than expected. What are the most efficient steps the data engineer can take directly within the Snowflake web UI to diagnose and potentially improve the query performance?

Options

• AUse the 'Profile' option in the worksheet to examine the query execution plan and identify
• BIncrease the warehouse size using the drop-down menu in the worksheet and rerun the query.
• CEnable caching for the query result by setting the parameter to TRUE in the worksheet.
• DDownload the query execution plan as a JSON file for offline analysis using external tools.
• EReview the Query History page in the web UI to analyze query statistics (e.g., execution time,

Explanation

The most efficient steps include profiling the query directly in the UI to identify bottlenecks (A), resizing the warehouse for more resources (B), and analyzing the Query History for insights from previous executions (E). Option C is not available directly in the worksheet. While downloading the execution plan (D) is helpful, it's not the most efficient initial step. Increasing Warehouse and query profiling directly address the performance within Snowflake.

No community discussion yet for this question.