Snowpro Core · Free Practice Question Easy
Question 95
Select the type of function that returns one value per invocation (one value per row).
- A Scalar Function
- B Window Function
- C Table Function
- D User-Defined Function
- E Aggregate Function
- F System Function
Reveal correct answer
Correct answer: A
Explanation
A scalar function is a function that returns one value per invocation; in most cases, you can think of this as returning one value per row. This contrasts with Aggregate Functions, which return one value per group of rows. Scalar functions take every row in your table, perform some calculations on that row and give you another value back.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
