Snowpro Core · Free Practice Question Easy
Question 56
Select the type of function that is used to execute an action in the system or return information about the system.
- A Aggregate Function
- B Table Function
- C Window Function
- D System Function
- E Scalar Function
- F User-Defined Function
Reveal correct answer
Correct answer: D
Explanation
System function that is used to execute an action in the system or return information about the system.
Snowflake provides the following types of system functions:
Control functions that allow you to execute actions in the system (e.g. aborting a query).
Information functions that return information about the system (e.g. calculating the clustering depth of a table).
Information functions that return information about queries (e.g. information about EXPLAIN plans).
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.
