SnowflakeSnowflake
DEA-C02 · Question #49
DEA-C02 Question #49: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C02 to reveal the answer and full explanation for question #49. The question stem and answer options stay visible for context.
Data Movement
Question
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?
Options
- ACreate a task in Snowflake that executes once a day and runs a COPY INTO statement that
- BOn the on-premise server, schedule a SQL file to run using SnowSQL that executes a PUT to
- COn the on-premise server, schedule a SQL file to run using SnowSQL that executes a PUT to
- DOn the on-premise server, schedule a Python file that uses the Snowpark Python library. The
Unlock DEA-C02 to see the answer
You've previewed enough free DEA-C02 questions. Unlock DEA-C02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Data Loading#Internal Stages#SnowSQL#Automation