SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ51

Data Ingestion and Data Preparation

An Architect bulk-loads CSV files into a table named TABLEA from its table stage by using COPY INTO with ON_ERROR = SKIP_FILE. One file, file5.csv, does not load successfully. The Architect corrects the file and uploads it to the stage again with exactly the same filename as before.

Which commands should the Architect use to load only file5.csv from the stage?

Choose two
Explanation

COPY INTO skips files that were already loaded successfully unless FORCE = TRUE is specified. A file skipped with ON_ERROR = SKIP_FILE was not successfully loaded, so a subsequent COPY from the stage loads the corrected file while continuing to ignore the previously successful files. The FILES option explicitly restricts a COPY operation to file5.csv.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!