ExamTopics Logo
Mail Us[email protected]
Menu
Snowflake Discussions
exam questions

Exam SnowPro Advanced Data Engineer All Questions

View all questions & answers for the SnowPro Advanced Data Engineer exam
Go to Exam

Exam SnowPro Advanced Data Engineer topic 1 question 49 discussion

Actual exam question from Snowflake's SnowPro Advanced Data Engineer
Question #: 49
Topic #: 1
[All SnowPro Advanced Data Engineer 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?

  • 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.
  • B. 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 task that executes once a day in Snowflake and runs a COPY INTO statement that references the internal stage. Schedule the task to start after the file lands in the internal stage.
  • 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.
  • D. On 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 Hide Answer
Suggested Answer: B 🗳️
by stopthisnow at Nov. 13, 2023, 10:26 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
aws_rajesh
2 weeks, 3 days ago
Option C, considering "LEAST amount of operational overhead" requirement in the question
upvoted 1 times
...
stopthisnow
7 months, 1 week ago
Selected Answer: B
B seems like a good option
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago