True or False: During data unloading, only JSON and CSV files can be compressed.
True or False: During data unloading, only JSON and CSV files can be compressed.
The statement is false. During data unloading, various file formats, including JSON, CSV, and Parquet, can be compressed. The question implies that only JSON and CSV can be compressed, which is incorrect since Parquet files can also be compressed.
During data loading, compression can be enabled for CSV, JSON PARQUET, AVRO, XML type files. ref: https://docs.snowflake.com/en/sql-reference/sql/create-file-format
question is on data 'unloading'
csv, json & parquet can be compressed
Data can be unloaded into csv,json and Parquet. so answer is False
B "By default, all unloaded data files are compressed using gzip, unless compression is explicitly disabled or one of the other supported compression methods is explicitly specified." https://docs.snowflake.com/en/user-guide/intro-summary-unloading
Along with JSON and CSV - Parquet files are also compressed while unloading https://docs.snowflake.com/en/sql-reference/sql/copy-into-location
Also Parquet file.. So false
Unloading supports structured formatting CSV format and unstructured JSON and Parquet formats only. Hence FALSE is correct answer.
CSV for structured data; JSON and Parquet for semi-structured data.
B. False
B is correct
only JSON and CSV formats can be unloaded into. Parquet AVro etc only for loading.
B.False