Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
SnowPro Core Certification · Snowflake
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
“With Snowpipe’s auto-ingest feature, Snowflake can be configured to listen to event notifications from cloud storage. When new data files are added, Snowpipe automatically loads them into a target table in Snowflake.”
D is not a good answer. When we have cloud provider notification, the AUTO-INGEST for SNOWPIPE has to be FALSE. A is good, due to the fact that it refers to External Stage and, in the "SNOWFLAKE language" when it is about Cloud Storage it is about files on External Stages. Hence, we have to load from External Stages to Table, using COPY INTO. Last idea, is what does the question understand by "with AUTO-INGEST"? AUTO-INGEST=TRUE or AUTO-INGEST=FALSE. I still remain to A.
D. Set up cloud provider notifications on the file location and use Snowpipe with auto-ingest.