exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 1109 discussion

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

What step does Snowflake recommend when loading data from a stage?

  • A. Use PURGE when using the COPY INTO [table] command.
  • B. Use REMOVE when using the COPY INTO [table] command.
  • C. Use the LOAD HISTORY function to view the status of loaded files.
  • D. Use the COPY HISTORY function to update the status of loaded files.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

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
MatthieuDN
1 month, 2 weeks ago
Selected Answer: C
Answer C seems correct
upvoted 1 times
...
Vicky4594
3 months ago
Selected Answer: DDD
Option D: snowpipe. Is a continuous data ingestion service in snowflake that automates the process of loading and structuring data
upvoted 1 times
...
athir
3 months, 3 weeks ago
because its only loading data, not Snowpipe, then I think its C. LOAD_HISTORY view: This view does not return the history of data loaded using Snowpipe. For this historical information, query the COPY_HISTORY view instead.
upvoted 1 times
...
d22770a
4 months, 3 weeks ago
Selected Answer: C
C is correct
upvoted 1 times
...
d22770a
4 months, 3 weeks ago
Answer for Q #1116 is C external function https://docs.snowflake.com/en/user-guide/unstructured-intro
upvoted 1 times
...
Lematthew31
6 months, 4 weeks ago
it's C the correct answer
upvoted 1 times
...
cybe001
9 months ago
Correct Answer: C. Use the LOAD HISTORY function to view the status of loaded files. Snowflake recommends using the COPY INTO <table> ... command to load data from a stage into a table. After the data is loaded, the LOAD HISTORY function (which can be accessed via the INFORMATION_SCHEMA.LOAD_HISTORY view or by querying the COPY_HISTORY table function) is used to view the status of loaded files. This helps to ensure that files are loaded correctly and to check for any errors during the load process.
upvoted 1 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago