SnowflakeSnowflake
COF-C02 · Question #221
COF-C02 Question #221: Real Exam Question with Answer & Explanation
The correct answer is C: $. VeryComprehensiveExplanation=InSnowflake,variablesaredenotedbyadollarsign(). Variables can be used in SQL statements where a literal constant is allowed, and they must be prefixed with a $ sign to distinguish them from bind values and column names.
Snowflake Cloud Data Platform Features and Architecture
Question
Using variables in Snowflake is denoted by using which SQL character?
Options
- A@
- B&
- C$
- D#
Explanation
VeryComprehensiveExplanation=InSnowflake,variablesaredenotedbyadollarsign(). Variables can be used in SQL statements where a literal constant is allowed, and they must be prefixed with a $ sign to distinguish them from bind values and column names.
Topics
#Variables#SQL Syntax#Session Variables
Community Discussion
No community discussion yet for this question.