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

Question

You are using Snowsight to analyze query performance. You notice a query that frequently accesses a table 'orders' is slow. Which of the following Snowsight features and actions could you use to identify potential bottlenecks and improve query performance? Select all that apply.

Options

• AExamine the query profile in Snowsight to identify stages with high execution time and resource
• BUse Snowsight's data lineage feature to trace the origin of the `orders' table and identify any
• CDisable query history in Snowsight to reduce the overhead on the system.
• DUse the 'Advisor' feature in Snowsight to receive recommendations on potential performance
• EReview the SQL text formatting in the query history to ensure it follows Snowflake's best practices.

Explanation

The query profile in Snowsight provides detailed information about each stage of a query's execution, allowing you to identify bottlenecks. The 'Advisor' feature offers recommendations for performance improvements. Data lineage (Option B) might be helpful in some cases, but it's not the most direct way to address query performance. Disabling query history (Option C) is counterproductive for performance analysis. Option E has no direct impact on query performance. Only relevant functions in Snowsight related to Snowflake are acceptable.

No community discussion yet for this question.