Snowflake
SOL-C01 · Question #249
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 ident
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #249. The question stem and answer options stay visible for context.
Querying and Performance
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.
Unlock SOL-C01 to see the answer
You've previewed enough free SOL-C01 questions. Unlock SOL-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Snowsight#Query Performance Tuning#Query Profile#Performance Advisor