SnowPro Advanced: Data Engineer — Question 28

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.)

Answer options

• A. HASH(*)
• B. HASH_AGG(*)
• C. HASH_AGG(<expr>, <expr>)
• D. HASH_AGG_COMPARE(*)
• E. HASH_COMPARE(*)

Correct answer: B, C

Explanation

The correct answers, B and C, utilize HASH_AGG to create a fingerprint over the specified expressions, which helps in detecting changes efficiently. Options A and E do not aggregate multiple values, while option D is not designed for creating fingerprints over entire datasets.