DEA-C02: SnowPro Advanced — Data Engineer

By Snowflake · Question Mode

QuestionQ8

VerifiedOfficial exam objectives/topics

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

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

Choose three
Explanation

SNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY contains query execution history and performance details for analyzing inefficient or long-running queries. SNOWFLAKE.ACCOUNT_USAGE.ACCESS_HISTORY identifies the users and data objects involved in access activity, supporting table-access analysis and governance auditing; it also includes policy-reference information. SNOWFLAKE.ACCOUNT_USAGE.WAREHOUSE_METERING_HISTORY reports credits consumed by each warehouse over time, which measures warehouse resource consumption.

Learn more

Community Discussion

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