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

Questions 31–32

1. 31foundation · easy

   Which statement accurately describes the primary purpose of the COPY INTO command in Snowflake?

   • ATo transform data within a table using SQL expressions.
   • BTo unload data from a table to files in a stage.
   • CTo load data from files in a stage into a Snowflake table.
   • DTo create a new stage for storing data files.
   Reveal Solution Discussion Select an answer first
2. 32application · medium

   A team has set up Snowpipe to load JSON files from an external stage. Some files are failing to load due to malformed JSON. The team wants to be notified automatically when a pipe fails, and they also want to review the details of failed loads. What should they configure?

   • AQuery the COPY_HISTORY table function to see failed loads.
   • BCreate a notification integration and set ERROR_NOTIFICATION to that integration in the pipe definition.
   • CSet the ON_ERROR option to CONTINUE in the pipe definition.
   • DUse the SYSTEM$PIPE_STATUS function to check the pipe's status.
   Reveal Solution Discussion Select an answer first