Load and Unload Data with COPY INTO and Snowpipe DEA-C02 Practice Questions (Page 7)

Questions 31–32

1. 31application · medium

   A company receives frequent, small batches of data files in an S3 bucket throughout the day. They need the data to appear in a Snowflake table within minutes of arrival, without manual intervention. Which Snowflake feature should they use?

   • ASnowpipe with auto-ingest enabled
   • BSnowpipe without auto-ingest, using REST calls
   • CCOPY INTO with a user-managed external stage
   • DCOPY INTO with a scheduled task every hour
   Reveal Solution Discussion Select an answer first
2. 32foundation · easy

   What is the purpose of the COPY INTO command when used for unloading data?

   • ATo copy data between tables in the same database
   • BTo read files from a stage into a table
   • CTo write table data to files in a stage or external location
   • DTo create a backup of the table in the same database
   Reveal Solution Discussion Select an answer first