Snowflake Exam ARA-C01 Topic 3 Question 48 Discussion

Actual exam question for Snowflake's ARA-C01 exam

Question #: 48
Topic #: 3

A company is trying to Ingest 10 TB of CSV data into a Snowflake table using Snowpipe as part of Its migration from a legacy database platform. The records need to be ingested in the MOST performant and cost-effective way.

How can these requirements be met?

AUse ON_ERROR = continue in the copy into command.

BUse purge = TRUE in the copy into command.

CUse FURGE = FALSE in the copy into command.

DUse on error = SKIP_FILE in the copy into command.

Show Suggested Answer

Suggested Answer: D

For ingesting a large volume of CSV data into Snowflake using Snowpipe, especially for a substantial amount like 10 TB, the on error = SKIP_FILE option in the COPY INTO command can be highly effective. This approach allows Snowpipe to skip over files that cause errors during the ingestion process, thereby not halting or significantly slowing down the overall data load. It helps in maintaining performance and cost-effectiveness by avoiding the reprocessing of problematic files and continuing with the ingestion of other data.

by Reynalda at Mar 21, 2025, 05:06 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Larae

8 days ago

Ah, the age-old debate: to continue or to skip? I say, why not both? Use 'on error = SKIP_FILE' and then go out for a nice, relaxing purge. Ah, the life of a data engineer.

upvoted 0 times

...

Vernell

16 days ago

I think using on error = SKIP_FILE would be the best option to skip files with errors and continue the ingestion process smoothly.

upvoted 0 times

...

Erick

17 days ago

Hmm, I'm not sure about these options. 'FURGE = FALSE'? Is that even a real Snowflake command? I think I'll go with option D, just to be safe.

upvoted 0 times

Leonor

7 days ago

Option C is definitely not a real Snowflake command. I would go with option D as well.

upvoted 0 times

...

Tonja

19 days ago

But wouldn't using ON_ERROR = continue help in case of any errors during ingestion?

upvoted 0 times

...

Julieta

20 days ago

I disagree, I believe using purge = TRUE in the copy into command would be more cost-effective.

upvoted 0 times

...

Valentin

25 days ago

Option B looks good to me. 'purge = TRUE' will remove the CSV files from the stage after they've been successfully ingested, so you don't have to worry about storage costs or management.

upvoted 0 times

Cordie

4 days ago

I agree, using 'purge = TRUE' is the most cost-effective way to handle the ingestion of the 10 TB of CSV data into Snowflake.

upvoted 0 times

...

Christoper

7 days ago

Option B looks good to me. 'purge = TRUE' will remove the CSV files from the stage after they've been successfully ingested, so you don't have to worry about storage costs or management.

upvoted 0 times

...

Tonja

26 days ago

I think we should use ON_ERROR = continue in the copy into command for better performance.

upvoted 0 times

...

Thaddeus

28 days ago

I think option D is the correct answer. 'on error = SKIP_FILE' allows you to skip any files with errors during the data ingestion process, which is more performant and cost-effective than having to manually intervene or restart the entire process.

upvoted 0 times

Malika

7 days ago

Yes, it's important to minimize any interruptions during the data ingestion process.

upvoted 0 times

...

Caprice

8 days ago

I think so too, skipping files with errors will definitely help with performance and cost.

upvoted 0 times

...

Margo

16 days ago

I agree, option D seems like the best choice for this scenario.

upvoted 0 times

...