DEA-C02: SnowPro Advanced — Data Engineer

By Snowflake · Question Mode

QuestionQ15

VerifiedOfficial exam objectives/topics

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

How should inefficient dynamic-table refreshes and resource usage be monitored?

Choose two
Explanation

Snowsight and DYNAMIC_TABLE_REFRESH_HISTORY provide dynamic-table refresh status, duration, and lag history. To evaluate virtual-warehouse resource use and sizing, correlate each refresh’s query ID with QUERY_HISTORY, which exposes metrics such as warehouse size, elapsed time, and credits. TASK_HISTORY applies to Snowflake tasks, not dynamic-table refresh monitoring. Snowflake: Monitor dynamic tables Snowflake: Understanding costs for dynamic tables

Learn more

Community Discussion

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