Load and Unload Data with COPY INTO and Snowpipe DEA-C02 Practice Questions (Page 4)

Questions 16–20

1. 16foundation · easy

   What does the PURGE copy option do when set to TRUE in a COPY INTO statement?

   • AClears the error files from the stage
   • BDeletes the source files from the stage after a successful load
   • CRemoves duplicate rows from the target table
   • DTruncates the target table before loading
   Reveal Solution Discussion Select an answer first
2. 17application · medium

   A data engineer is loading files from an internal stage into a table. After a successful load, the engineer wants the files to be automatically deleted from the stage to save storage costs. Which COPY INTO option should be used?

   • ASIZE_LIMIT = 1
   • BPURGE = TRUE
   • CFORCE = TRUE
   • DON_ERROR = 'CONTINUE'
   Reveal Solution Discussion Select an answer first
4. 18application · medium

   A data engineer is loading a daily CSV export from an internal named stage into a table. The export occasionally contains a few malformed rows that should be skipped, but any file with more than 5% bad rows indicates a systemic issue and should fail the entire load. Which COPY INTO option set should the engineer use?

   • AON_ERROR = 'SKIP_FILE_5%'
   • BON_ERROR = 'CONTINUE' with a separate validation query
   • CON_ERROR = 'SKIP_FILE'
   • DON_ERROR = 'CONTINUE'
   Reveal Solution Discussion Select an answer first
5. 19foundation · easy

   Which clause in a COPY INTO statement is used to specify the target columns and apply transformations during load?

   • ASELECT
   • BFILE_FORMAT
   • CFROM
   • DON_ERROR
   Reveal Solution Discussion Select an answer first
6. 20foundation · easy

   What is the purpose of using VALIDATION_MODE in a COPY INTO statement?

   • ATo check for errors in the data files before loading
   • BTo load only valid rows and skip invalid ones
   • CTo delete files that are not valid
   • DTo transform data during the load
   Reveal Solution Discussion Select an answer first