ARA-C01 practice question 17 of 25
An Architect uses COPY INTO with the ON_ERROR=SKIP_FILE option to bulk load CSV files into a table called TABLEA, using its table stage. One file named file5.csv fails to load. The Architect fixes the file and re-loads it to the stage with the exact same file name it had previously. Which commands should the Architect use to load only file5.csv file from the stage? (Choose two.)
Full set: 162 questionsOption A (RETURN_FAILED_ONLY) will only load files that previously failed to load. Since file5.csv already exists in the stage with the same name, it will not be considered a new file and will not be loaded.
Option D (FORCE) will overwrite any existing data in the table. This is not desired as we only want to load the data from file5.csv.
Option E (NEW_FILES_ONLY) will only load files that have been added to the stage since the last COPY command. This will not work because file5.csv was already in the stage before it was fixed.
Option F (MERGE) is used to merge data from a stage into an existing table, creating new rows for any data not already present. This is not needed in this case as we simply want to load the data from file5.csv. Therefore, the architect can use either COPY INTO tablea FROM @%tablea or COPY INTO tablea FROM @%tablea FILES = ('file5.csv') to load only file5.csv from the stage. Both options will load the data from the specified file without overwriting any existing data or requiring additional configuration
Keep practicing
Take the free ARA-C01 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other ARA-C01 practice questions
- Question 1An Architect needs to improve the performance of reports that pull data from multiple Sno…
- Question 2What is a characteristic of event notifications in Snowpipe?
- Question 3Based on the Snowflake object hierarchy, what securable objects belong directly to a Snow…
- Question 4An Architect has designed a data pipeline that Is receiving small CSV files from multiple…
- Question 5Which data models can be used when modeling tables in a Snowflake environment? (Select TH…
- Question 6A user has the appropriate privilege to see unmasked data in a column. If the user loads …
