SnowPro Core Certification — Question 515

What type of function can be used to estimate the approximate number of distinct values from a table that has trillions of rows?

Answer options

• A. MD5
• B. Window
• C. External
• D. HyperLogLog (HLL)

Correct answer: D

Explanation

HyperLogLog (HLL) is specifically designed for approximating the number of distinct elements in large datasets efficiently. In contrast, MD5 is a hashing function, while Window and External do not pertain to this type of estimation, making them unsuitable for the given scenario.