SnowPro Advanced: Data Engineer — Question 101

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

Which combination of views should the Engineer use to meet these requirements? (Choose three.)

Answer options

• A. SNOWFLAKE.ACCOUNT_USAGE.OBJECT_DEPENDENCIES view to track dependencies between objects.
• B. Use the SNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY view to analyze query performance.
• C. Use the SNOWFLAKE.ACCOUNT_USAGE.SCHEMA_PRIVILEGES view to ensure compliance with data governance policies.
• D. Use the SNOWFLAKE.ACCOUNT_USAGE.DATABASE_STORAGE_USAGE_HISTORY view to analyze historical storage usage across databases.
• E. Use the SNOWFLAKE.ACCOUNT_USAGE.ACCESS_HISTORY view to track access patterns.
• F. Use the SNOWFLAKE.ACCOUNT_USAGE.WAREHOUSE_METERING_HISTORY view to monitor warehouse resource consumption.

Correct answer: B, E, F

Explanation

The correct options B, E, and F provide the necessary insights into query performance, access patterns, and warehouse resource consumption, which are essential for optimizing workloads. Options A and C do not directly address performance metrics or query efficiency, while option D focuses solely on historical storage usage, which is not a priority for the Engineer's requirements.