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

Questions 11–15

1. 11expert · hard

   A company uses Snowpipe to load data from an external stage. They notice that some files are not being loaded and there are no error notifications. They want to troubleshoot the issue. Which sequence of steps is most appropriate?

   • ADisable and re-enable the pipe to reset its state.
   • BImmediately recreate the pipe with a new name.
   • CCheck the stage's storage location and ensure files are present.
   • DCheck the pipe's status with SYSTEM$PIPE_STATUS, review COPY_HISTORY for errors, and verify the notification integration is configured correctly.
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   How does Snowpipe detect new files in an internal stage?

   • AIt uses a notification integration to receive events.
   • BIt scans the stage on a schedule defined by the user.
   • CIt requires a user to manually run the pipe.
   • DIt polls the stage every few minutes.
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   Which COPY INTO option deletes files from the stage after they have been successfully loaded?

   • AON_ERROR
   • BPURGE
   • CVALIDATION_MODE
   • DFORCE
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   Which COPY INTO option controls the behavior when errors are encountered during a load?

   • AFILE_FORMAT
   • BVALIDATION_MODE
   • CPURGE
   • DON_ERROR
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   What is the primary purpose of Snowpipe?

   • ATo unload data from Snowflake to external storage
   • BTo load data continuously as new files arrive in a stage
   • CTo create file formats for data loading
   • DTo transform data within a table using SQL
   Reveal Solution Discussion Select an answer first