SnowPro Core Certification — Question 666

What is the Snowflake recommended Parquet file size when querying from external tables to optimize the number of parallel scanning operations?

Answer options

• A. 1-16 MB
• B. 16-128 MB
• C. 100-250 MB
• D. 256-512 MB

Correct answer: D

Explanation

The correct answer is D, as Snowflake recommends that Parquet files be between 256 MB and 512 MB to maximize parallel processing during queries. Options A, B, and C suggest sizes that are either too small or do not fully leverage Snowflake's optimization capabilities, leading to less efficient scanning.