Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Snowflake Exam DEA-C01 Topic 4 Question 46 Discussion

Actual exam question for Snowflake's DEA-C01 exam
Question #: 46
Topic #: 4
[All DEA-C01 Questions]

A CSV file around 1 TB in size is generated daily on an on-premise server A corresponding table. Internal stage, and file format have already been created in Snowflake to facilitate the data loading process

How can the process of bringing the CSV file into Snowflake be automated using the LEAST amount of operational overhead?

Show Suggested Answer Hide Answer
Suggested Answer: C

This option is the best way to automate the process of bringing the CSV file into Snowflake with the least amount of operational overhead. SnowSQL is a command-line tool that can be used to execute SQL statements and scripts on Snowflake. By scheduling a SQL file that executes a PUT command, the CSV file can be pushed from the on-premise server to the internal stage in Snowflake. Then, by creating a pipe that runs a COPY INTO statement that references the internal stage, Snowpipe can automatically load the file from the internal stage into the table when it detects a new file in the stage. This way, there is no need to manually start or monitor a virtual warehouse or task.


Contribute your Thoughts:

Tequila
2 days ago
The correct answer is C. Snowpipe will automatically load the file from the internal stage when the new file lands, which is the least amount of operational overhead.
upvoted 0 times
...
Leatha
7 days ago
I think option A is the best choice. It seems like the most straightforward way to automate the process with minimal overhead.
upvoted 0 times
...

Save Cancel