SnowPro Core Certification — Question 1312

A Snowflake user is trying to load a 125 GB file using SnowSQL. The file continues to load for almost an entire day.

What will happen at the 24-hour mark?

Answer options

• A. The file will continue to load until all contents are loaded.
• B. The file will stop loading and all data up to that point will be committed.
• C. The file loading could be aborted without any portion of the file being committed.
• D. The file’s number of allowable hours to load can be programmatically controlled to load easily into Snowflake.

Correct answer: C

Explanation

The correct answer is C because if a file loading exceeds the maximum time limit, Snowflake can abort the process without committing any data. Option A is incorrect as the loading will not continue indefinitely. Option B is wrong because not all data would be committed if the loading is aborted. Option D is misleading since there is no programmatic control over the maximum loading time.