SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ88

Design and Manage Snowflake Resources and Performance

A Data Engineer must monitor data-usage patterns, performance metrics, and query efficiency to optimize data workloads in a Snowflake account. The Engineer requires insight into long-running queries, frequently accessed tables, and warehouse resource utilization, while also tracking user activity and ensuring compliance with governance policies.

Which combination of views should the Engineer use to satisfy these requirements?

Choose three
Explanation

SNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY supplies query execution history for performance analysis, including information that can identify long-running and inefficient queries. SNOWFLAKE.ACCOUNT_USAGE.ACCESS_HISTORY records access to Snowflake objects, enabling analysis of table access patterns and user activity for audit and governance purposes. SNOWFLAKE.ACCOUNT_USAGE.WAREHOUSE_METERING_HISTORY reports hourly warehouse credit usage, enabling monitoring of warehouse resource consumption.

Learn more

Community Discussion

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