DEA-C02: SnowPro Advanced — Data EngineerDemo

By Snowflake · Question Mode

QuestionQ49

Official exam objectives/topics

A table is loaded through Snowpipe and subsequently truncated. Later, a Data Engineer determines that the table must be reloaded, but the pipe metadata prevents the same files from being loaded again.

How can this problem be resolved with the least operational overhead?

  • A Wait until the metadata expires and then reload the file using Snowpipe.
  • B Modify the file by adding a blank row to the bottom and re-stage the file.
  • C Set the FORCE=TRUE option in the Snowpipe COPY INTO command.
  • D Recreate the pipe by using the CREATE OR REPLACE PIPE command.
Explanation

Snowpipe stores file-loading history in the pipe object, and truncating the target table does not remove that history. Recreating the pipe with CREATE OR REPLACE PIPE removes the pipe-associated file-load metadata, allowing the files to be loaded again. FORCE = TRUE is not supported in a Snowpipe pipe definition, while waiting for metadata expiry or modifying and restaging files requires more operational effort.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!