Snowflake Exam DEA-C01 Topic 4 Question 46 Discussion

Actual exam question for Snowflake's DEA-C01 exam

Question #: 46
Topic #: 4

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?

ACreate a task in Snowflake that executes once a day and runs a copy into statement that references the internal stage The internal stage will read the files directly
from the on-premise server and copy the newest file into the table from the on-premise server to the Snowflake table

BOn the on-premise server schedule a SQL file to run using SnowSQL that executes a PUT to push a specific file to the internal stage Create a task that executes once a
day m Snowflake and runs a OOPY WTO statement that references the internal stage Schedule the task to start after the file lands in the internal stage

COn the on-premise server schedule a SQL file to run using SnowSQL that executes a PUT to push a specific file to the internal stage. Create a pipe that runs a copy
into statement that references the internal stage Snowpipe auto-ingest will automatically load the file from the internal stage when the new file lands in the internal
stage.

DOn the on premise server schedule a Python file that uses the Snowpark Python library. The Python script will read the CSV data into a DataFrame and generate an
insert into statement that will directly load into the table The script will bypass the need to move a file into an internal stage

Show Suggested 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.

by Yan at Apr 04, 2025, 03:10 AM

Limited Time Offer

25%

Off

Get Premium DEA-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Erick

1 months ago

Haha, did someone say 1 TB CSV file? That's a whole lot of data! I hope they have a good internet connection on that on-premise server.

upvoted 0 times

...

Lindsey

1 months ago

Hmm, I'm not so sure. What if the file is too big for Snowpipe to handle? Maybe option D using Snowpark Python would be better.

upvoted 0 times

Ngoc

2 days ago

I agree, Snowpipe is designed for automatic ingestion of large files. It would be the least amount of operational overhead.

upvoted 0 times

...

Harrison

3 days ago

Option C sounds like a good choice. Snowpipe can handle large files efficiently.

upvoted 0 times

...

Glennis

2 months ago

I agree, C is the best option. Automating the process with Snowpipe is the way to go. No need to manually run tasks or scripts.

upvoted 0 times

Shala

2 days ago

A) Create a task in Snowflake that executes once a day and runs a copy into statement that references the internal stage The internal stage will read the files directly from the on-premise server and copy the newest file into the table from the on-premise server to the Snowflake table

upvoted 0 times

...

Buddy

12 days ago

I agree, C is the best option. Automating the process with Snowpipe is the way to go. No need to manually run tasks or scripts.

upvoted 0 times

...

Weldon

1 months ago

C) On the on-premise server schedule a SQL file to run using SnowSQL that executes a PUT to push a specific file to the internal stage. Create a pipe that runs a copy into statement that references the internal stage Snowpipe auto-ingest will automatically load the file from the internal stage when the new file lands in the internal stage.

upvoted 0 times

...

Vashti

2 months ago

I see your points, but I personally prefer option D. Using a Python script to directly load the data into the table without the need for an internal stage sounds like a more flexible approach.

upvoted 0 times

...

Terrilyn

2 months ago

I disagree, I believe option C is more efficient. Using Snowpipe auto-ingest to automatically load the file seems like a time-saving solution.

upvoted 0 times

...

Tequila

2 months 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