Answer: Directory

The correct answer is B (Directory table). Directory tables are specifically designed in Snowflake for file processing pipelines with unstructured data. They track file-level metadata (names, sizes, timestamps, URLs) for files in internal or external stages, enabling streams and tasks to detect new or changed files and invoke processing functions. While comment 1562054 initially suggested C (Standard), the community consensus (67% for B) and subsequent clarification confirm that Directory tables are the specialized table type for this purpose. Standard tables (C) handle structured row-column data, Temporary tables (A) are session-scoped for structured data, and Transient tables (D) are similar to standard but without fail-safe protection - none of these are designed for unstructured file processing pipelines.

Author: LeetQuiz Editorial Team