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'
Along with JSON and CSV - Parquet files are also compressed while unloading https://docs.snowflake.com/en/sql-reference/sql/copy-into-location
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
Data can be unloaded into csv,json and Parquet. so answer is False
csv, json & parquet can be compressed
B. False
CSV for structured data; JSON and Parquet for semi-structured data.
Unloading supports structured formatting CSV format and unstructured JSON and Parquet formats only. Hence FALSE is correct answer.
Also Parquet file.. So false
B.False
only JSON and CSV formats can be unloaded into. Parquet AVro etc only for loading.
B is correct