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

Questions 26–30

1. 26foundation · easy

   In a COPY INTO command, which file format option specifies the character used to separate fields in a CSV file?

   • ASKIP_HEADER
   • BNULL_IF
   • CFIELD_DELIMITER
   • DRECORD_DELIMITER
   Reveal Solution Discussion Select an answer first
2. 27application · medium

   A company wants to use Snowpipe to load files from an external stage in Amazon S3. They have already created the stage and a file format. What additional components must they create to enable Snowpipe to automatically ingest new files?

   • AA notification integration and a stored procedure that calls COPY INTO.
   • BA pipe and a warehouse that is always running.
   • CA storage integration and a task that runs COPY INTO on a schedule.
   • DA notification integration for S3 event notifications and a pipe that references the stage and file format.
   Reveal Solution Discussion Select an answer first
4. 28foundation · easy

   Which of the following is required to create a Snowpipe?

   • AA notification integration for all pipes
   • BA stage and a file format
   • CA task to schedule the pipe
   • DA virtual warehouse
   Reveal Solution Discussion Select an answer first
5. 29expert · hard

   A team loads millions of small CSV files (each < 1 MB) from an external stage using COPY INTO. The load is very slow and they suspect the number of files is the bottleneck. They want to improve performance without changing the warehouse size. Which approach is most effective?

   • ASet the PURGE option to TRUE in the COPY INTO command.
   • BIncrease the parallelism by setting the PARALLEL parameter to a higher value.
   • CConsolidate the small files into fewer, larger files before loading.
   • DUse a file format with a higher compression level.
   Reveal Solution Discussion Select an answer first
6. 30application · easy

   A startup wants to load data from a Kafka topic into Snowflake in near real-time. They are considering using Snowpipe. What is the primary advantage of using Snowpipe for this use case compared to running COPY INTO manually?

   • ASnowpipe automatically loads new files as they arrive, without requiring manual intervention.
   • BSnowpipe provides a built-in Kafka connector that directly reads from Kafka topics.
   • CSnowpipe guarantees exactly-once delivery of data.
   • DSnowpipe can transform data using complex SQL functions during loading.
   Reveal Solution Discussion Select an answer first