Exam SnowPro Core All QuestionsBrowse all questions from this exam
Go to Exam
Question 307

Using variables in Snowflake is denoted by using which SQL character?

    Correct Answer: C

    In Snowflake, variables are denoted by the $ character. This syntax is used to distinguish variables from other identifiers in SQL queries.

Discussion
SV1122Option: C

set (min, max)=(40, 70); select $min; select avg(salary) from emp where age between $min and $max; https://docs.snowflake.com/en/sql-reference/session-variables.html#:~:text=Using%20Variables%20in%20SQL,-Variables%20can%20be&text=To%20distinguish%20them%20from%20bind,be%20prefixed%20with%20a%20%24%20sign.&text=Because%20the%20%24%20sign%20is%20the,character%20when%20used%20in%20identifiers.

_yyuktaOption: C

C is correct

MultiCloudIronManOption: C

correct

Madhavan71Option: C

Selected Answer: C

Rob__C

https://docs.snowflake.com/en/sql-reference/session-variables.html#variable-identifiers

halolOption: C

correct