SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ19

Design and Manage Snowflake Resources and Performance

A company created data pipelines with dynamic tables in Snowflake. Recently, certain dynamic table refreshes have taken longer than expected, delaying data availability for downstream reporting and increasing costs.

How should inefficient dynamic table refreshes and resource utilization be monitored?

Choose two
Explanation

Snowsight and DYNAMIC_TABLE_REFRESH_HISTORY provide dynamic-table refresh status, duration, lag, and related refresh details. Dynamic-table refreshes execute on their assigned virtual warehouse, and QUERY_HISTORY can be correlated with refresh query IDs or filtered by warehouse to assess elapsed time, compute usage, and whether the warehouse is appropriately sized. Monitor dynamic tables and Understanding costs for dynamic tables document these monitoring approaches.

Learn more

Community Discussion

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