Load Data Using COPY INTO and Snowpipe COF-C03 Practice Questions (Page 2)

Questions 6–10

1. 6foundation · easy

   Which SQL command is used to load data from files in a named stage into a Snowflake table?

   • AMERGE INTO my_table FROM @my_stage
   • BLOAD DATA INTO my_table FROM @my_stage
   • CCOPY INTO my_table FROM @my_stage
   • DINSERT INTO my_table FROM @my_stage
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   Which SQL command is used to create a Snowpipe?

   • ACREATE STAGE
   • BCREATE PIPE
   • CCREATE SNOWPIPE
   • DCREATE TASK
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   How can you configure a Snowpipe to send notifications when errors occur during loading?

   • ASet the ERROR_INTEGRATION property on the pipe.
   • BCreate a task to monitor the pipe.
   • CEnable the PIPE_ERRORS parameter.
   • DUse the ON_ERROR option in the COPY INTO statement.
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   In a COPY INTO command, which clause allows you to specify a column list to map source fields to target table columns?

   • A(col1, col2, ...)
   • BFILE_FORMAT
   • CCOLUMN_MAPPING
   • DTRANSFORM
   Reveal Solution Discussion Select an answer first
6. 10application · medium

   A data analyst is loading a CSV file that has a few rows with extra columns and some rows with invalid numeric values. They want to load the valid rows and skip the problematic ones, but they also want to see a summary of the errors. Which COPY INTO option should they use?

   • AON_ERROR = CONTINUE
   • BFORCE = TRUE
   • CON_ERROR = ABORT_STATEMENT
   • DVALIDATION_MODE = RETURN_ERRORS
   Reveal Solution Discussion Select an answer first