DEA-C02: SnowPro Advanced — Data Engineer

By Snowflake · Question Mode

QuestionQ59

VerifiedOfficial exam objectives/topics

A Data Engineer is setting up dependencies in the load process for a dynamic table, SALES.

Which setting makes SALES refresh when a downstream dependent dynamic table is refreshed?

Explanation

TARGET_LAG = DOWNSTREAM gives an intermediate dynamic table no independent refresh schedule. Snowflake refreshes it when a downstream dynamic table needs to refresh. REFRESH_MODE controls the processing method, while a time-based target lag specifies a freshness target.

Learn more

Community Discussion

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