You have a need to make external file data available to your users with the lowest latency. The files are on an external stage in AWS.

You have a need to make external file data available to your users with the lowest latency. The files are on an external stage in AWS.

What feature of Snowflake is the most appropriate to use
A . Materialized View
B. SnowPipe
C. Secure View

View Answer

Answer: B

Explanation:

Snowpipe is Snowflake’s continuous data ingestion service. It provides a pipeline for loading new data as soon as it is available, either in an internal or external stage. Please also remember that SNOWPIPE can ingest from both external and internal stage. Internal stage is supported by the rest APIs and not AUTO ingest. This is important to know for the exam.

A materialized view is a pre-computed data set derived from a query specification (the SELECT in the view definition) and stored for later use. Because the data is pre-computed, querying a materialized view is faster than executing the original query. This performance difference can be significant when a query is run frequently or is sufficiently complex.

So materialized view helps in making the query run faster once it is refreshed with data, but SnowPipe is the one which makes the data available almost instantly.