COF-C03: SnowPro Core Certification

By Snowflake · Question Mode

QuestionQ89

Performance Optimization, Querying & Transformation

Which view in the SNOWFLAKE.ACCOUNT_USAGE schema lets a user identify opportunities to optimize a slow-running query?

Explanation

SNOWFLAKE.ACCOUNT_USAGE.QUERY_INSIGHTS returns insights generated for queries, including detected performance conditions and suggested actions. Its is_opportunity field identifies insights that include recommendations to improve query performance.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!