exam questions

Exam SnowPro Advanced Data Engineer All Questions

View all questions & answers for the SnowPro Advanced Data Engineer exam

Exam SnowPro Advanced Data Engineer topic 1 question 42 discussion

Actual exam question from Snowflake's SnowPro Advanced Data Engineer
Question #: 42
Topic #: 1
[All SnowPro Advanced Data Engineer Questions]

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

  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
DIPARJ
4 days, 3 hours ago
Selected Answer: C
Currently, only JavaScript variables of type number, string, and SfDate can be bound.
upvoted 1 times
...
prshntdxt7
8 months, 3 weeks ago
Selected Answer: C
C. Only JavaScript variables of type number, string, and SfDate can be bound. In Snowflake, when using binding variables in JavaScript stored procedures, only JavaScript variables of certain types can be bound. These types are typically limited to number, string, and SfDate. Options A and B are incorrect because not all types of JavaScript variables or all Snowflake first-class objects can be bound. There are restrictions on the types of variables that can be used as binding variables. Option D is incorrect because users are not restricted from binding JavaScript variables due to SQL injection concerns. The use of binding variables is a good practice to prevent SQL injection vulnerabilities as it helps separate SQL logic from user input, making it more secure.
upvoted 1 times
...
Snow_P
10 months, 2 weeks ago
Selected Answer: C
https://docs.snowflake.com/en/developer-guide/stored-procedure/stored-procedures-javascript
upvoted 3 times
...
stopthisnow
10 months, 3 weeks ago
Selected Answer: C
The data type of the variable should be appropriate for the use of the value in the SQL statement. Currently, only JavaScript variables of type number, string, and SfDate can be bound.
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago