All of these will convert to a value of FALSE https://docs.snowflake.net/manuals/sql-reference/data-types-logical.html#boolean-conversion

There is a Boolean data type which can store TRUE / FALSE information

The maximum size of data that a VARCHAR column can store is 16 MB uncompressed. The maximum number of characters that can be stored in a VARCHAR depends on if the character is a single byte character or 2 bytes or multibyte. In case of single byte the maximum length of VARCHAR is 1677216

https://docs.snowflake.net/manuals/sql-reference/data-types-text.html#varchar

You can use only the "supported" functions when querying data in a Snowflake stage. https://docs.snowflake.net/manuals/user-guide/querying-stage.html#supported-functions

The files are first unloaded to an internal stage from where they can be downloaded locally using the GET command https://docs.snowflake.net/manuals/user-guide/intro-summary-unloading.html#output-data-file-details

All data at rest i.e. data in tables, data in internal stages etc.. Is encrypted automatically

https://docs.snowflake.net/manuals/user-guide/security-encryption.html

Snowflake prevents data duplication by maintaining metadata and ignoring files that have already been loaded.

https://docs.snowflake.net/manuals/user-guide/data-load-snowpipe-intro.html#data-duplication

External tables support all file formats that are supported by the COPY command

https://docs.snowflake.net/manuals/user-guide/tables-external-intro.html

The BINARY data type can store 8MB of data https://docs.snowflake.net/manuals/sql-reference/data-types-text.html#binary

Snowflake allows unloading data into a single or multiple files. This can be controlled by changing the COPY command option SINGLE from TRUE to FALSE.

https://docs.snowflake.net/manuals/user-guide/data-unload-overview.html#bulk-unloading-into-single-or-multiple-files