Answer: Named file format

The correct answer is D (Named file format) because Snowflake specifically recommends using named file format objects when unloading similarly formatted data on a regular schedule. Named file formats encapsulate all required format options (file type, compression, delimiters, etc.) in a reusable database object, which streamlines COPY INTO operations by eliminating the need to repeatedly specify the same options. This aligns with Snowflake best practices for operational efficiency and consistency. The community discussion confirms this with 100% consensus on answer D and provides detailed reasoning about the benefits of named file formats for regular unloading operations. Other options are less suitable: A (Stream) is for change data capture, B (Task) is for scheduling, and C (Storage integration) is for connecting to external cloud storage.

Author: LeetQuiz Editorial Team