SnowPro Core Certification — Question 751

What consideration should be made when loading data into Snowflake?

Answer options

• A. Create small data files and stage them in cloud storage frequently.
• B. Create large data files to maximize the processing overhead for each file.
• C. The number of load operations that run in parallel can exceed the number of data files to be loaded.
• D. The number of data files that are processed in parallel is determined by the virtual warehouse.

Correct answer: D

Explanation

The correct answer is D because the virtual warehouse in Snowflake dictates how many files can be processed simultaneously. Option A is incorrect as creating small files can lead to inefficiencies, while option B is not optimal since larger files can also introduce processing overhead. Option C is misleading; the number of load operations is dependent on the virtual warehouse capacity rather than exceeding the number of files.