SnowPro Core Certification — Question 348

What is Snowflake's general guideline for files used to load data?

Answer options

• A. Files can be loaded directly into a table.
• B. Any delimiter is supported: the default is a semicolon.
• C. Electronic Data Interchange (EDI) is one of the supported semi-structured formats.
• D. For delimited files, the default character set is UTF-8.

Correct answer: D

Explanation

The correct answer is D because Snowflake specifies that the default character set for delimited files is UTF-8, which is important for ensuring proper data loading. Option A is inaccurate because files must typically be staged before being loaded into a table. Option B is misleading as Snowflake has specific delimiter requirements and does not support all delimiters. Option C is irrelevant to the question about file character sets.