SnowPro Core Certification — Question 332

A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command:

COPY INTO my_table FROM @my_stage;

The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.

If the user runs the same COPY INTO command what will happen?

Answer options

• A. All data from all of the files on the stage will be appended to the table.
• B. Only data about new customers from the new files will be appended to the table.
• C. The operation will fail with the error UNCERTAIN FILES IN STAGE.
• D. All data from only the newly-added files will be appended to the table.

Correct answer: D

Explanation

The correct answer is D because the COPY INTO command only processes new files added to the stage since the last load, ignoring any existing files. Options A and B are incorrect as they suggest that data from previous files or all files will be appended, which is not the behavior of the COPY INTO command. Option C is also incorrect because the operation does not fail in this scenario; it simply processes the new files.