COF-C02 Question 404

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose C1

  Load history Bulk data load Stored in the metadata of the target table for 64 days. Available upon completion of the COPY statement as the statement output. Snowpipe Stored in the metadata of the pipe for 14 days. Must be requested from Snowflake via a REST endpoint, SQL table function, or ACCOUNT_USAGE view.

• 1

  1. The load history for Snowpipe operations is stored in the metadata of the pipe object , it remains for 14 days. When a pipe is recreatedthe load history is dropped

• Chose C1

  Load history is stored in the metadata of the target table for 64 days