COF-C02 · Question #645
What Snowflake objects can contain custom application logic written in JavaScript? (Select TWO)
The correct answer is A. Stored procedures E. User-Defined Functions (UDFs). Both Stored Procedures and User-Defined Functions (UDFs) in Snowflake support JavaScript as an authoring language. Stored procedures can contain complex procedural logic - loops, conditionals, error handling - written in JavaScript (as well as Python, Java, and Scala). UDFs can…
Question
What Snowflake objects can contain custom application logic written in JavaScript? (Select TWO)
Options
- AStored procedures
- BStages
- CTasks
- DViews
- EUser-Defined Functions (UDFs)
How the community answered
(40 responses)- A95% (38)
- C3% (1)
- D3% (1)
Explanation
Both Stored Procedures and User-Defined Functions (UDFs) in Snowflake support JavaScript as an authoring language. Stored procedures can contain complex procedural logic - loops, conditionals, error handling - written in JavaScript (as well as Python, Java, and Scala). UDFs can similarly be written in JavaScript to implement custom scalar or tabular transformation logic. Stages are file storage locations with no execution logic. Tasks are scheduled SQL or stored procedure calls, but tasks themselves do not contain inline JavaScript. Views are purely SQL-based and do not support custom code.
Topics
Community Discussion
No community discussion yet for this question.