SnowPro Advanced: Data Engineer — Question 37

What is a characteristic of the use of binding variables in JavaScript stored procedures in Snowflake?

Answer options

• A. All types of JavaScript variables can be bound.
• B. All Snowflake first-class objects can be bound.
• C. Only JavaScript variables of type number, string, and SfDate can be bound.
• D. Users are restricted from binding JavaScript variables because they create SQL injection attack vulnerabilities.

Correct answer: C

Explanation

The correct answer is C, as only JavaScript variables of specific types like number, string, and SfDate can be bound in Snowflake. Options A and B are incorrect because they overstate the types that can be bound, while option D is wrong since binding is not entirely restricted, but rather limited to specific types to mitigate security risks.