Files arrive in an external stage every 10 seconds from a proprietary system. The files range in size from 500 K to 3 MB. The data must be accessible by dashboards as soon as it arrives. How can a Sno

Question

Options

• AUse Snowpipe with auto-ingest.
• BUse a COPY command with a task.
• CUse a materialized view on an external table.
• DUse the COPY INTO command.
• EUse a combination of a task and a stream.

• A
  71% (12)
• B
  6% (1)
• C
  6% (1)
• D
  18% (3)

Explanation

A is correct: Snowpipe with auto-ingest uses cloud event notifications (e.g., S3 SQS events or Azure Event Grid) to automatically trigger file loading as soon as files arrive in the external stage. This requires minimal code - just defining a pipe object and enabling auto-ingest. E is correct: A stream on the target table captures new rows loaded by Snowpipe, and a task can be scheduled to process those changes for downstream dashboards, completing the pipeline with minimal additional coding. B (COPY command with task) is insufficient because tasks have a minimum 1-minute scheduling interval, which cannot meet a 10-second arrival cadence. C (materialized view on external table) queries data in place but doesn't load it for fast dashboard access. D (COPY INTO) is a manual command requiring external orchestration.

No community discussion yet for this question.