SnowPro Core Certification — Question 1186

Which strings will be converted to TRUE using the TO_BOOLEAN() or CAST() functions when unloading data? (Choose two.)

Answer options

• A. 0
• B. n
• C. no
• D. on
• E. yes

Correct answer: D, E

Explanation

The strings 'on' and 'yes' are recognized as TRUE values by the TO_BOOLEAN() and CAST() functions. In contrast, '0', 'n', and 'no' will be interpreted as FALSE, which is why they are not correct answers.