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

Questions 16–20

1. 16foundation · easy

   Which scenario is best suited for using COPY INTO instead of Snowpipe?

   • ALoading new files as they arrive every few minutes
   • BAutomating loads without manual intervention
   • CLoading a large batch of historical data once
   • DLoading data continuously from a streaming source
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   What is a key difference in cost between using COPY INTO and Snowpipe?

   • ASnowpipe is always more expensive than COPY INTO.
   • BSnowpipe does not incur any cost.
   • CCOPY INTO has no compute cost.
   • DCOPY INTO uses a virtual warehouse that you manage and pay for, while Snowpipe uses Snowflake-managed compute.
   Reveal Solution Discussion Select an answer first
4. 18application · medium

   A data engineer is loading a CSV file into a Snowflake table using COPY INTO. The file contains a header row, uses a pipe delimiter, and represents missing values as the string 'N/A'. The target table has columns in a different order than the file. Which COPY INTO statement correctly handles these requirements?

   • ACOPY INTO t FROM @stage/file.csv FILE_FORMAT = (TYPE = CSV FIELD_DELIMITER = ',' SKIP_HEADER = 0 NULL_IF = ('NULL'))
   • BCOPY INTO t FROM @stage/file.csv FILE_FORMAT = (TYPE = CSV FIELD_DELIMITER = '|' SKIP_HEADER = 1 NULL_IF = ('N/A'))
   • CCOPY INTO t FROM @stage/file.csv FILE_FORMAT = (TYPE = CSV FIELD_DELIMITER = '|' SKIP_HEADER = 1 NULL_IF = ('N/A')) FORCE = TRUE
   • DCOPY INTO t (col2, col1) FROM @stage/file.csv FILE_FORMAT = (TYPE = CSV FIELD_DELIMITER = '|' SKIP_HEADER = 1 NULL_IF = ('N/A'))
   Reveal Solution Discussion Select an answer first
5. 19expert · hard

   A company is evaluating whether to use Snowpipe or COPY INTO for a new data ingestion pipeline. The data arrives in bursts: 100 files every 5 minutes during business hours, and no files at night. They need the data to be available within 10 minutes of arrival. Which approach best balances cost and latency?

   • AUse a single COPY INTO command at the end of the day.
   • BUse Snowpipe with a warehouse that is always running to ensure low latency.
   • CUse a scheduled COPY INTO task that runs every 10 minutes during business hours.
   • DUse Snowpipe, which will automatically load files as they arrive, with compute costs only for the actual load operations.
   Reveal Solution Discussion Select an answer first
6. 20application · easy

   A data engineer wants to validate a CSV file before actually loading it into a table. They want to see any errors that would occur without loading the data. Which COPY INTO option should they use?

   • AVALIDATION_MODE = RETURN_ERRORS
   • BON_ERROR = CONTINUE
   • CFORCE = TRUE
   • DPURGE = TRUE
   Reveal Solution Discussion Select an answer first