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

17 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

25 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

...

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

13 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

16 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

1 months ago

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

upvoted 0 times

...

25 days ago

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

upvoted 0 times

...