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

Questions 21–25

1. 21foundation · easy

   Which view or function can be used to monitor the load history of a Snowpipe?

   • ACOPY_HISTORY
   • BPIPE_HISTORY
   • CINFORMATION_SCHEMA.PIPE_USAGE_HISTORY
   • DINFORMATION_SCHEMA.COPY_HISTORY
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   Which COPY INTO option allows you to validate data files without actually loading them into the table?

   • APURGE
   • BVALIDATION_MODE
   • CFORCE
   • DON_ERROR
   Reveal Solution Discussion Select an answer first
4. 23foundation · easy

   Which of the following is a recommended practice to optimize COPY INTO performance?

   • AUse a single large file for all data
   • BLoad data directly from external sources without staging
   • CSplit data into multiple files of similar size to enable parallelism
   • DLoad many small files instead of fewer large files
   Reveal Solution Discussion Select an answer first
5. 24application · medium

   A team has set up Snowpipe to load files from an internal stage. They notice that some files are not being loaded. They want to check the status of the pipe and see which files have been processed. Which approach should they use?

   • ACheck the pipe's definition using SHOW PIPES.
   • BQuery the COPY_HISTORY table function and the SYSTEM$PIPE_STATUS function.
   • CQuery the STAGE_STORAGE_USAGE view.
   • DUse the LIST command on the stage to see which files remain.
   Reveal Solution Discussion Select an answer first
6. 25foundation · easy

   Which of the following best describes the event-driven architecture of Snowpipe?

   • AIt uses a virtual warehouse to continuously run queries.
   • BIt uses a scheduled task to load data at regular intervals.
   • CIt requires manual execution of a COPY INTO command.
   • DIt triggers a load when new files are added to a stage.
   Reveal Solution Discussion Select an answer first