SnowPro Core Certification — Question 886

What type of function returns one value for each invocation?

Answer options

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

Correct answer: B

Explanation

The correct answer is B, Scalar, as it is designed to return a single value per execution. In contrast, Aggregate functions return a single result from a set of values, Table functions return a table, and Window functions operate over a set of rows related to the current row.