Which functions will compute a 'fingerprint' over an entire table, query result, or window to quickly detect changes to table contents or query results? (Choose two.)
Which functions will compute a 'fingerprint' over an entire table, query result, or window to quickly detect changes to table contents or query results? (Choose two.)
To compute a 'fingerprint' over an entire table, query result, or window to quickly detect changes to table contents or query results, the functions HASH(*) and HASH_AGG(*) are appropriate. HASH(*) generates a hash value for the input data, while HASH_AGG(*) aggregates multiple hash values and is suitable for windows or sets of rows. Other options either do not exist or are not relevant for the task.
https://docs.snowflake.com/en/sql-reference/functions/hash_agg There is no hash_agg_compare function.
A and B. C is not correct because is not needed to include 2 expressions. https://docs.snowflake.com/en/sql-reference/functions/hash_agg https://docs.snowflake.com/en/sql-reference/functions/hash
No hash_agg_compare function