What is the only supported character set for loading and unloading data from all supported file formats?

The correct answer is A. UTF-8. UTF-8 is the only character encoding supported by Snowflake for loading and unloading data across all supported file formats (CSV, JSON, Avro, Parquet, ORC, XML). Snowflake stores all data internally in UTF-8 and requires source files to be UTF-8 encoded. UTF-16 (B), ISO-8859-1…

Data Loading and Unloading

Question

Options

AUTF-8
BUTF-16
CISO-8859-1
DWINDOWS-1253

How the community answered

(47 responses)

A
87% (41)
B
4% (2)
C
6% (3)
D
2% (1)

Explanation

UTF-8 is the only character encoding supported by Snowflake for loading and unloading data across all supported file formats (CSV, JSON, Avro, Parquet, ORC, XML). Snowflake stores all data internally in UTF-8 and requires source files to be UTF-8 encoded. UTF-16 (B), ISO-8859-1 (C), and WINDOWS-1253 (D) are not supported. If source data is in a different encoding, it must be converted to UTF-8 before loading into Snowflake.

Topics

#Character set#Data loading#Data unloading#File formats

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice