Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Choose two.)
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Choose two.)
When loading data into Snowflake, it's best practice to load files that are approximately 100-250 MB (or larger) because larger files are more efficient for bulk loading operations. Additionally, it is recommended to avoid using embedded characters such as commas for numeric data types to prevent errors during data loading.
https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare.html https://www.snowflake.com/blog/best-practices-for-data-ingestion/
correct answer https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare.html#preparing-delimited-text-files
C & D => correct answer
C and D are correct
C & D. Ref : https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare
Correct
C,D is correct
Avoid embedded characters, such as commas (e.g. 123,456). https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare.html#preparing-delimited-text-files