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.)
To meet the requirement of making data accessible by dashboards as soon as it arrives with the least amount of coding, the best approach involves using automated and minimal hands-on configurations. Snowpipe with auto-ingest allows for continuous loading of data with minimal setup and maintenance, ensuring that the data is available quickly. Additionally, using a materialized view on an external table can automatically refresh and provide up-to-date data without manual intervention, reducing the need for extensive coding while ensuring the data is always current and readily accessible.
A&E is my guess
A is definitely valid Correct me if I'm wrong. E is also valid because if we set STREAM_HAS_DATA it will trigger the task to run to insert data although schedule has been set.
I think this is also true but the question says: with the LEAST amount of coding
Sorry, I think STREAM_HAS_DATA can not change the scheduling of a task: This function is intended to be used in the WHEN expression in the definition of tasks. If the specified stream contains no change data, the task skips the current run. And this can not be correct because of the charemski comment.
Minimum schedule time for a task is 60 seconds, so in this case only Snowpipe or Materialized View on External Table, in either case using event notification service https://docs.snowflake.com/en/user-guide/tables-external-intro#materialized-views-over-external-tables
Answer is A,B and is validated
COPY command does not exist (option b).
A: Just define one object: the Pipe object with included COPY INTO ... FROM Stage ... command B: Just define one object: the scheduled Task object with included COPY INTO ... FROM Stage ... command
I think A & C are the answers
A & E is the right answer