Snowflake supports a variety of file formats for unloading semi-structured data, among which Parquet and Newline Delimited JSON (NDJSON) are two widely used formats.
B . Binary file in Parquet: Parquet is a columnar storage file format optimized for large-scale data processing and analysis. It is especially suited for complex nested data structures.
D . Newline Delimited JSON (NDJSON): This format represents JSON records separated by newline characters, facilitating the storage and processing of multiple, separate JSON objects in a single file.
These formats are chosen for their efficiency and compatibility with data analytics tools and ecosystems, enabling seamless integration and processing of exported data.
Reference:
Snowflake Documentation: Data Unloading

To unload data from a table into one or more files in a named stage, the COPY INTO <location> command should be used. This command exports the result of a query, such as selecting all rows from a table, into files stored in the specified stage. The COPY INTO command is versatile, supporting various file formats and compression options for efficient data unloading.
References:
* Snowflake Documentation: COPY INTO Location

When creating a Snowpark-optimized virtual warehouse in Snowflake, the minimum size requirement is Small. Snowpark is designed to handle data processing workloads efficiently, and the Small size ensures adequate resources for such tasks.
Virtual Warehouse Sizes:
Snowflake offers different sizes for virtual warehouses, ranging from X-Small to 6X-Large.
Each size corresponds to a specific level of compute resources.
Minimum Size Requirement for Snowpark:
A Small virtual warehouse is the minimum size required to optimize performance and resource allocation for Snowpark workloads.
This ensures that the warehouse has sufficient capacity to handle data processing and transformation tasks efficiently.
Snowflake Documentation: Virtual Warehouse Sizes