SnowPro Core Certification — Question 1075

What step does Snowflake recommend when loading data from a stage?

Answer options

• A. Use PURGE when using the COPY INTO [table] command.
• B. Use REMOVE when using the COPY INTO [table] command.
• C. Use the LOAD HISTORY function to view the status of loaded files.
• D. Use the COPY HISTORY function to update the status of loaded files.

Correct answer: A

Explanation

The correct answer is A, as Snowflake suggests using PURGE to remove files from the stage after successfully loading them. Option B is incorrect because REMOVE is not the recommended action after loading. Options C and D refer to functions that do not impact the loading process directly.