Answer-first summary for fast verification
Answer: For delimited files, the default character set is UTF-8.
The question asks about Snowflake's general guidelines for files used to load data. Option D is correct because Snowflake documentation confirms that UTF-8 is the default character set for delimited files, ensuring proper encoding handling. Option A is incorrect because while COPY INTO can load from external locations, the general guideline involves staging files first for better performance and reliability, as noted in the community discussion. Option B is incorrect because the default delimiter is a comma, not a semicolon. Option C is incorrect because EDI is not a supported semi-structured format in Snowflake. The community consensus strongly supports D with 96% agreement and detailed reasoning about why other options are wrong.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What is Snowflake's recommended file format for data loading?
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.
No comments yet.