SnowPro Advanced: Architect — Question 43

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 Snowflake Architect meet this requirement with the LEAST amount of coding? (Choose two.)

Answer options

• A. Use Snowpipe with auto-ingest.
• B. Use a COPY command with a task.
• C. Use a materialized view on an external table.
• D. Use the COPY INTO command.
• E. Use a combination of a task and a stream.

Correct answer: A, E

Explanation

The correct answer includes A, which allows for real-time data loading with minimal coding through Snowpipe's auto-ingest feature. Option E is also correct as it leverages a task and a stream to continuously load data. The other options involve more complex processes or do not provide immediate accessibility to the data.