
Explanation:
The question asks for two best practice recommendations for loading data into Snowflake. Option C is correct because Snowflake recommends loading files that are 100-250 MB or larger for optimal performance, as smaller files can lead to inefficiencies in parallel processing. Option D is correct because avoiding embedded characters like commas in numeric data types prevents parsing issues during data loading, especially with delimited text files. Option A is incorrect as it recommends loading very small files (25 MB or smaller), which contradicts Snowflake's best practices. Option B is incorrect because removing all dates and timestamps is not a general best practice; it depends on the data requirements. Option E is incorrect because semi-structured data types (e.g., JSON, Avro) are natively supported in Snowflake and do not need to be removed.
Ultimate access to all questions.
Which of the following are best practice recommendations for loading data into Snowflake? (Choose two.)
A
Load files that are approximately 25 MB or smaller.
B
Remove all dates and timestamps.
C
Load files that are approximately 100-250 MB (or larger).
D
Avoid using embedded characters such as commas for numeric data types.
E
Remove semi-structured data types.
No comments yet.