COF-C02 · Question #14
COF-C02 Question #14: Real Exam Question with Answer & Explanation
Sign in or unlock COF-C02 to reveal the answer and full explanation for question #14. The question stem and answer options stay visible for context.
Question
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?
Options
- AAll data from all of the files on the stage will be appended to the table.
- BOnly data about new customers from the new files will be appended to the table.
- CThe operation will fail with the error uncertain files in stage.
- DAll data from only the newly-added files will be appended to the table.
Unlock COF-C02 to see the answer
You've previewed enough free COF-C02 questions. Unlock COF-C02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.