DEA-C02 Question #69: Real Exam Question with Answer & Explanation

Question

Which attribute is used by Snowpipe to ensure the same file is not loaded twice from a path in a stage? File partition details A.

Options

• BFile checksum
• CCreation_time of the file

Explanation

The question formatting appears incomplete - Choice A's text ("File partition details") got mixed into the question body, and Choice D's text is missing entirely. Based on Snowflake documentation, D is most likely "File path (file name/path within the stage)", which is the correct answer.

Snowpipe tracks each successfully ingested file by its unique file path within the stage, recording it in Snowflake's load history metadata. When a new file notification arrives, Snowpipe checks this history - if the exact path already exists, the file is skipped, preventing duplicate loads.

Why the distractors are wrong:

• A (File partition details): Partitioning is a query optimization concept; Snowpipe does not use partition metadata to deduplicate ingestion.
• B (File checksum): Snowpipe does not compute or compare checksums for deduplication - two files with identical content but different paths would both be loaded.
• C (Creation_time): Timestamps are not unique identifiers; multiple files could share the same timestamp, making this unreliable for deduplication.

Memory tip: Think of Snowpipe's load history as a "receipt book" - each receipt records the exact file path, not what's inside the file or when it was created. If the path is already in the book, the file is ignored.

No community discussion yet for this question.