Which of the following can be used when unloading data from Snowflake? (Choose two.)
Which of the following can be used when unloading data from Snowflake? (Choose two.)
When unloading semi-structured data from Snowflake, the STRIP_OUTER_ARRAY option is often recommended to remove the outermost array from the unloaded JSON data. Additionally, using the SINGLE = TRUE parameter allows exporting a single file up to 5 GB in size to the storage layer. These two methods are well-suited for the specified use cases when unloading data from Snowflake.
https://docs.snowflake.com/en/user-guide/data-unload-considerations.html
Answer is CD
correct
https://docs.snowflake.com/en/user-guide/data-unload-considerations CD
C: https://docs.snowflake.com/en/user-guide/data-unload-considerations#unloading-a-relational-table-to-json D: https://docs.snowflake.com/en/user-guide/data-unload-considerations#unloading-to-a-single-file
Specifically mentioned in Snowflake Documentation: "Output files are always encoded using UTF-8, regardless of the file format; no other character sets are supported." https://docs.snowflake.com/en/user-guide/intro-summary-unloading#:~:text=File%20encoding,sets%20are%20supported.
D - can be exported to the storage layer - Does storage layer really means STAGE !! ??
To me both BCD looks right. Regarding B you can use a file format for unloading (https://docs.snowflake.com/en/user-guide/data-unload-prepare.html) And you can use ENCODING to change it https://docs.snowflake.com/en/sql-reference/sql/create-file-format.html