Snowflake Exam DEA-C01 Topic 5 Question 34 Discussion

Actual exam question for Snowflake's DEA-C01 exam

Question #: 34
Topic #: 5

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 Margot at Sep 15, 2024, 02:59 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Ruthann

2 months ago

Wait, a 1 TB CSV file? That's a lot of data! I hope whoever came up with this question has a lot of free time on their hands. Maybe they should use a file compression tool or something.

upvoted 0 times

...

2 months ago

Option D looks interesting, but I'm not sure if it would be the 'least amount of operational overhead' as the question asks. Bypassing the internal stage might introduce some complexity.

upvoted 0 times

Felice

1 months ago

C: Option C also sounds like a good option with the auto-ingest feature of Snowpipe to automatically load the file from the internal stage.

upvoted 0 times

...

Beckie

2 months ago

B: I agree, using a task in Snowflake to copy the newest file from the on-premise server into the table seems efficient.

upvoted 0 times

...

Miles

2 months ago

A: Option A seems like the best choice for automating the process with the least amount of operational overhead.

upvoted 0 times

...

Lavonda

2 months ago

I see both points, but I think option B could also work well. Scheduling a SQL file to run using SnowSQL and then creating a task in Snowflake seems like a good approach too.

upvoted 0 times

...

3 months ago

Option C seems the most efficient way to automate the process. Snowpipe will take care of the loading when the file lands in the internal stage, reducing operational overhead.

upvoted 0 times

Kimbery

2 months ago

I agree, Snowpipe definitely simplifies the process and reduces the manual steps needed for loading the data into Snowflake.

upvoted 0 times

...

Chau

2 months ago

Option C seems the most efficient way to automate the process. Snowpipe will take care of the loading when the file lands in the internal stage, reducing operational overhead.

upvoted 0 times

...