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

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam
Go to Exam

Exam SnowPro Core topic 1 question 302 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 302
Topic #: 1
[All SnowPro Core Questions]

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 Hide Answer
Suggested Answer: D 🗳️
by halol at Dec. 16, 2022, 12:45 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
MultiCloudIronMan
3 months, 3 weeks 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
2 months, 4 weeks ago
I really dont understand the question
upvoted 1 times
...
...
6c79d6f
7 months 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
8 months, 2 weeks ago
Selected Answer: D
D is correct
upvoted 2 times
...
Heetec
1 year, 1 month 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
10 months, 2 weeks 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
10 months, 2 weeks ago
B: the new files could contains both old and new data.
upvoted 1 times
...
...
Marge23
1 year, 1 month 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, 7 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
1 year, 9 months ago
Selected Answer: D
D is correct answer
upvoted 2 times
...
sakis213
1 year, 10 months ago
Selected Answer: D
only the new files will be appended
upvoted 2 times
...
AS314
1 year, 10 months 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
1 year, 10 months 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
1 year, 10 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
1 year, 9 months 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
...
...
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