SnowPro Core Recertification — Question 20

What type of function returns one value for each invocation?

Answer options

• A. Aggregate
• B. Scalar
• C. Table
• D. Window

Correct answer: B

Explanation

A Scalar function is designed to return a single value for each call, making it suitable for computations that require a singular result. In contrast, Aggregate functions return a summary value from a set of values, Table functions return a table, and Window functions perform calculations across a set of rows related to the current row.