Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 302 discussion

Actual exam question from Snowflake's SnowPro Core

Question #: 302
Topic #: 1

A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command:

COPY INTO my_table FROM @my_stage;

The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.

If the user runs the same COPY INTO command what will happen?

A. All data from all of the files on the stage will be appended to the table.
B. Only data about new customers from the new files will be appended to the table.
C. The operation will fail with the error UNCERTAIN FILES IN STAGE.
D. All data from only the newly-added files will be appended to the table.

Show Suggested Answer

Suggested Answer: D 🗳️

by halol at Dec. 16, 2022, 12:45 p.m.

Comments

Submit Cancel

MultiCloudIronMan

7 months ago

Selected Answer: A

According to the Snowflake documentation, when you run the COPY INTO command again without removing the original files, all data from all of the files on the stage will be appended to the table

upvoted 1 times

MultiCloudIronMan

6 months, 1 week ago

I really dont understand the question

upvoted 1 times

...

6c79d6f

10 months, 2 weeks ago

Selected Answer: D

Once the files are copied into a table, they cannot be copied again in the next 64 days because of the files’ metadata. If this option is true, it loads all files, regardless of whether they’ve been loaded previously and have not changed since they were loaded. https://plazagonzalo.medium.com/snowflake-snowpro-data-loading-f88afaef7eb9#cf88

upvoted 1 times

...

_yyukta

11 months, 4 weeks ago

Selected Answer: D

D is correct

upvoted 2 times

...

Heetec

1 year, 4 months ago

what s the difference between B) and D) the meaning is the same, only data from new files will be added...

upvoted 1 times

VASI250

1 year, 1 month ago

B Mentions only new customers from the new files meaning any duplicates in new files will be removed while loading which is not true. All the data from new files will be loaded as LOAD HISTORY is maintained by snowflake. So D is correct answer with this question.

upvoted 1 times

...

gizzamo

1 year, 1 month ago

B: the new files could contains both old and new data.

upvoted 1 times

...

Marge23

1 year, 5 months ago

Selected Answer: D

D is correct Loading Older Files¶ This section describes how the COPY INTO <table> command prevents data duplication differently based on whether the load status for a file is known or unknown. If you partition your data in stages using logical, granular paths by date (as recommended in Organizing Data by Path) and load data within a short period of time after staging it, this section largely does not apply to you. However, if the COPY command skips older files (i.e. historical data files) in a data load, this section describes how to bypass the default behavior. https://docs.snowflake.com/en/user-guide/data-load-considerations-load#executing-parallel-copy-statements-that-reference-the-same-data-files

upvoted 1 times

...

EmiB

1 year, 11 months ago

Selected Answer: D

D - only the new files will be appended B - SF doesn't know which customer is new (COPY doesn't care about the meaning of data, care about files (file names) which are new (no kept in metadata as loaded)

upvoted 3 times

...

fahfouhi94

2 years ago

Selected Answer: D

D is correct answer

upvoted 2 times

...

sakis213

2 years, 1 month ago

Selected Answer: D

only the new files will be appended

upvoted 2 times

...

AS314

2 years, 1 month ago

Selected Answer: D

https://docs.snowflake.com/en/user-guide/data-load-considerations-load.html#executing-parallel-copy-statements-that-reference-the-same-data-files

upvoted 4 times

...

yogen

2 years, 1 month ago

D - COPY command maintains historic load metadata with target table , so day 1 , 10 files will will not be loaded again

upvoted 3 times

...

halol

2 years, 2 months ago

Selected Answer: A

https://community.snowflake.com/s/question/0D50Z00009T3JWXSA3/upload-data-to-table-and-avoid-duplicated-data-rows

upvoted 2 times

BigDataBB

2 years, 1 month ago

Copy into not reload the same file more times if you don't set force = true https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html#reloading-files - Reloading Files Add FORCE = TRUE to a COPY command to reload (duplicate) data from a set of staged data files that have not changed (i.e. have the same checksum as when they were first loaded).

upvoted 4 times

...