An Architect needs to design a data unloading strategy for Snowflake, that will be used with the COPY INTO
Which configuration is valid?
For the configuration of data unloading in Snowflake, the valid option among the provided choices is 'C.' This is because Snowflake supports unloading data into Google Cloud Storage using the COPY INTO <location> command with specific configurations. The configurations listed in option C, such as Parquet file format with UTF-8 encoding and gzip compression, are all supported by Snowflake. Notably, Parquet is a columnar storage file format, which is optimal for high-performance data processing tasks in Snowflake. The UTF-8 file encoding and gzip compression are both standard and widely used settings that are compatible with Snowflake's capabilities for data unloading to cloud storage platforms. Reference:
Snowflake Documentation on COPY INTO command
Snowflake Documentation on Supported File Formats
Snowflake Documentation on Compression and Encoding Options
Ressie
10 days agoJamal
13 days agoLynelle
19 days agoAntonio
20 days agoAlton
2 days agoAngella
5 days agoJani
10 days agoMollie
11 days agoShannan
21 days agoMila
28 days agoCarlton
1 months agoAlexia
27 days agoGary
1 months ago