SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ96

Transform Data

Which functions calculate a “fingerprint” across an entire table, query result, or window in order to quickly identify changes to table contents or query results?

Choose two
Explanation

HASH_AGG produces an aggregate signed 64-bit hash across the unordered input rows and can be used as either an aggregate or window function. It accepts a wildcard for all columns or one or more expressions, so both listed HASH_AGG forms can fingerprint a table, query result, or window. Snowflake HASH_AGG documentation

Learn more

Community Discussion

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